Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-analysis-functions.html
MySQL provides functions to perform various operations on spatial data.
https://dev.mysql.com/doc/refman/8.4/en/spatial-function-argument-handling.html
In MySQL, the SRID value is an integer associated with the geometry value. In MySQL, the only valid empty geometry is represented in the form of an empty geometry collection. Spatial values, or geometries, have the properties described in Section ...