Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-fractional-seconds.html
However, when Connector/J inserted a java.sql.TIME into the server as a MySQL TIME value, the fractional seconds were always truncated. While a java.sql.TIME instance, according to the JDBC specification, is not supposed to contain fractional ...
https://dev.mysql.com/doc/connectors/en/connector-j-query-attributes.html
Connector/J supports Query Attributes when it has been enabled on the server by installing the query_attributes component (see Prerequisites for Using Query Attributes for details). Attributes are set for a query by using the setAttribute() method ...
Connectors and APIs Manual :: 3.5.12.4 Connecting Using Web Authentication (WebAuthn) Authentication
https://dev.mysql.com/doc/connectors/en/connector-j-WebAuthn-authentication.html
In either case, issue the following command (additional command options to connect to the right server might be needed): $ mysql --user=johndoe --password1 --register-factor=2 Enter password: <type "s3cr3t"> Please insert FIDO device and follow the ... Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric ...
https://dev.mysql.com/doc/connectors/en/connector-j-YEAR.html
Connector/J follows the same rules that govern how values are inserted by a mysql client; see explanations in The YEAR Type for details. How a value in a MySQL YEAR column is handled is controlled by the connection property yearIsDateType: If ...
https://dev.mysql.com/doc/connectors/en/connector-net-authentication.html
MySQL Connector/NET implements a variety of authentication plugins that MySQL Server can invoke to authenticate a user. Pluggable authentication enables the server to determine which plugin applies, based on the user name and host name that your ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-example.html
Insert the following code into the existing Program.cs file, replacing the default C# code. The Code First approach enables you to define an entity model in code, create a database from the model, and then add data to the database. MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-mysqlcommand.html
Class methods enable you to perform the following database operations: Query a database Insert, update, and delete data Return a single value Command-based database operations can run within a transaction, if needed. The MySqlCommand class ...
https://dev.mysql.com/doc/connectors/en/connector-net-using-character-sets.html
To insert 4-byte UTF8 strings into blob columns, use the .NET Encoding.GetBytes function to convert your string to a series of bytes. Treating Binary Blobs As UTF8 Before the introduction of 4-byte UTF-8 character set, MySQL did not support 4-byte ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-architecture.html
The database is used as the source of the data (during queries) and the destination for data (during inserts and updates). The Connector/ODBC architecture is based on five components, as shown in the following diagram: Figure 5.1 Connector/ODBC ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-overview.html
For Delete / Update / Insert the results might include the number of rows affected. Interacting with a MySQL server from an applications using the Connector/ODBC typically involves the following operations: Configure the Connector/ODBC DSN. This ...