Search Results
https://dev.mysql.com/doc/refman/8.4/en/row-constructor-optimization.html
However, the row constructor itself does not cover an index prefix, with the result that the optimizer uses only c1 (key_len=4, the size of c1): mysql> EXPLAIN SELECT * FROM t1 WHERE c1=1 AND (c2,c3) > (1,1)\G *************************** 1. For ...
https://dev.mysql.com/doc/refman/8.4/en/set-transaction.html
transaction_characteristic: { ISOLATION LEVEL level | access_mode } level: { REPEATABLE READ | READ COMMITTED | READ UNCOMMITTED | SERIALIZABLE } access_mode: { READ WRITE | READ ONLY } This statement specifies transaction characteristics. It takes ...
https://dev.mysql.com/doc/refman/8.4/en/show-binary-log-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci */ /*!80014 DEFAULT ENCRYPTION='N' */ mysql> SHOW CREATE SCHEMA test\G ... SHOW CREATE {DATABASE ...
https://dev.mysql.com/doc/refman/8.4/en/show-databases.html
SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server host. MySQL implements databases as directories in the data directory, so this statement simply lists directories in that location. The ...
https://dev.mysql.com/doc/refman/8.4/en/show-parse-tree.html
Note This statement is available only in debug builds, or if the MySQL server was built using -DWITH_SHOW_PARSE_TREE. Example: mysql> SHOW PARSE_TREE SELECT * FROM t3 WHERE o_id > 2\G *************************** 1. SHOW PARSE_TREE select_statement ...
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server supports. The privileges displayed include all static privileges, and all currently registered dynamic privileges. row *************************** Privilege: ...
https://dev.mysql.com/doc/refman/8.4/en/shutdown.html
SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command. A successful SHUTDOWN sequence consists of checking the privileges, validating the arguments, and sending an OK packet to the client.
https://dev.mysql.com/doc/refman/8.4/en/source-thread-states.html
If the incompatible changes have an impact for you, set the terminology_use_previous system variable to BEFORE_8_0_26 to make MySQL Server use the old versions of the names for the objects specified in the previous list. The following list shows ...