Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-installing-upgrading.html
This section has information for users who are upgrading from one version of Connector/J to another, or to a new version of the MySQL server that supports a more recent level of JDBC. Depending on the platform and the way you used to install ...A ...
https://dev.mysql.com/doc/connector-j/en/connector-j-named-pipe.html
As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group, which specifies a Windows local group containing the user by which the client application JVM (and thus ...
https://dev.mysql.com/doc/connector-j/en/connector-j-schema-validation.html
This is done by specifying a JSON Schema during Collection creation or modification; schema validation is then performed by the server at a document creation or update, and an error is returned if the document does not validate against the assigned ... When working with MySQL Server 8.0.19 and later: Schema validation can be configured for a Collection, so that documents in the Collection are validated against a schema before they can be inserted or ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
Consider the following series of statements for example: conn.createStatement().execute( "UPDATE checking_account SET balance = balance - 1000.00 WHERE customer='Smith'"); conn.createStatement().execute( "UPDATE savings_account SET balance = balance ... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
The value for either variable can be NULL or a string containing one or more comma-separated account names, each in user_name@host_name format. Modifications to audit_log_include_accounts or audit_log_exclude_accounts affect only connections created ... Note This section describes legacy audit log filtering, which applies if the audit_log plugin is installed without the accompanying audit tables and functions needed for rule-based ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/8.4/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/8.4/en/charset-restrictions.html
Identifiers are stored in mysql database tables (user, db, and so forth) using utf8mb3, but identifiers can contain only characters in the Basic Multilingual Plane (BMP). FULLTEXT indexes cannot be created on a column that uses any of these ...The ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin.html
By default, a remote cloning operation removes existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory before cloning data from the donor. The clone plugin permits cloning data locally or from a ...