Search Results
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
"affected rows" for DML statements, but does cause correct update counts from "INSERT ... connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-prepared-statements.html
Default Value true Since Version 3.1.12 useServerPrepStmts Use server-side prepared statements if the server supports them? The server may limit the number of prepared statements with 'max_prepared_stmt_count' or disable them altogether. In case of ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.
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 ...