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-events.html
It requires the EVENT privilege for the database from which the events are to be shown. SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in ...
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
This statement requires some privilege for any column in the table. SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index information. row *************************** Table: city ...
https://dev.mysql.com/doc/refman/5.7/en/show-master-status.html
SHOW MASTER STATUS This statement provides status information about the binary log files of the source. row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: ...
https://dev.mysql.com/doc/refman/5.7/en/show-open-tables.html
If you have no privileges for a table, it does not show up in the output from SHOW OPEN TABLES. SHOW OPEN TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW OPEN TABLES lists the non-TEMPORARY tables that are currently open 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. If you do not specify 'log_name', the first relay log is displayed. The ...
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. Host: The host name of the replica server as specified on the replica with the ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. If you issue this statement using the mysql client, you can use a \G statement terminator rather than a semicolon to ...
https://dev.mysql.com/doc/refman/5.7/en/show-tables.html
If you have no privileges for a base table or view, it does not show up in the output from SHOW TABLES or mysqlshow db_name. SHOW [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...