PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
SHOW CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name Shows the CREATE DATABASE statement that creates the named database. If the SHOW statement includes an IF NOT EXISTS clause, the output too includes such a clause. row ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT NULL AUTO_INCREMENT, `s` char(60) DEFAULT NULL, PRIMARY KEY (`id`) ...To use this statement, you must have some privilege for the ...
https://dev.mysql.com/doc/refman/5.7/en/show-status.html
SHOW [GLOBAL | SESSION] STATUS [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information available from and privileges required for the statement described here. SHOW STATUS provides server ...
https://dev.mysql.com/doc/refman/5.7/en/show-character-set.html
SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The WHERE clause can be given to select rows using more general conditions, as discussed in Section 24.8, ...The LIKE ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. Use of SHOW CREATE VIEW requires the SHOW VIEW privilege, and the SELECT privilege for the view in question. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The WHERE clause ...This statement requires some privilege for any column in the ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a replica. Note Issuing a SHOW RELAYLOG EVENTS with no LIMIT clause could start a ...If you do not specify 'log_name', the first relay log is ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
SHOW SLAVE HOSTS Displays a list of replicas currently registered with the source. SHOW SLAVE HOSTS should be executed on a server that acts as a replication source. Statement output includes this column only if the source server is started with ...
https://dev.mysql.com/doc/refman/5.7/en/show-binary-logs.html
SHOW BINARY LOGS SHOW MASTER LOGS Lists the binary log files on the server. This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. A ...
https://dev.mysql.com/doc/refman/5.7/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 WHERE clause can be given to select rows using more general ...