Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
The following items summarize other potential incompatibilities: SET NAMES 'utf8mb4' causes use of the 4-byte character set for connection character sets. This section describes issues that you may face when converting character data between the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
Connecting to the donor MySQL server instance through MySQL Router is not supported. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/commit.html
If the read_only system variable is enabled, explicitly starting a transaction with START TRANSACTION READ WRITE requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). See Chapter 31, Connectors and APIs, or the documentation ...SET autocommit disables or enables the default autocommit mode for the current ...
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
See Obtaining Auto-Increment Values, and the description for the FLAG_AUTO_IS_NULL option at Connector/ODBC Connection Parameters. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ... CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...Values of ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
Just specify its name after any connection parameters that you might need to provide. If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) and ...Note An ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-client.html
If you have problems with your own client code, you should attempt to connect to the server and run your query using a client that is known to work. To be able to debug a MySQL client with the integrated debug package, you should configure MySQL ...