Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
It may be a good idea to run mysqladmin -i10 processlist status in some window if you are experiencing performance problems or problems when new clients cannot connect. If you are using some functionality that is very new in MySQL, you can try to ...
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...