SHOW语句
SHOW
具有许多形式,可提供有关数据库,表,列或有关服务器的状态信息的信息。本节介绍以下内容:
SHOW {BINARY |MASTER }LOGS SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]SHOW CHARACTER SET [like_or_where]SHOW COLLATION [like_or_where]SHOW [FULL ]COLUMNS FROM tbl_name [FROM db_name] [like_or_where]SHOW CREATE DATABASE db_nameSHOW CREATE EVENT event_nameSHOW CREATE FUNCTION func_nameSHOW CREATE PROCEDURE proc_nameSHOW CREATE TABLE tbl_nameSHOW CREATE TRIGGER trigger_nameSHOW CREATE VIEW view_nameSHOW DATABASES [like_or_where]SHOW ENGINE engine_name {STATUS |MUTEX }SHOW [STORAGE ]ENGINES SHOW ERRORS [LIMIT [offset,] row_count]SHOW EVENTS SHOW FUNCTION CODE func_nameSHOW FUNCTION STATUS [like_or_where]SHOW GRANTS FOR userSHOW INDEX FROM tbl_name [FROM db_name]SHOW MASTER STATUS SHOW OPEN TABLES [FROM db_name] [like_or_where]SHOW PLUGINS SHOW PROCEDURE CODE proc_nameSHOW PROCEDURE STATUS [like_or_where]SHOW PRIVILEGES SHOW [FULL ]PROCESSLIST SHOW PROFILE [types] [FOR QUERY n] [OFFSET n] [LIMIT n]SHOW PROFILES SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count]SHOW SLAVE HOSTS SHOW SLAVE STATUS [FOR CHANNEL channel]SHOW [GLOBAL |SESSION ]STATUS [like_or_where]SHOW TABLE STATUS [FROM db_name] [like_or_where]SHOW [FULL ]TABLES [FROM db_name] [like_or_where]SHOW TRIGGERS [FROM db_name] [like_or_where]SHOW [GLOBAL |SESSION ]VARIABLES [like_or_where]SHOW WARNINGS [LIMIT [offset,] row_count] like_or_where: LIKE 'pattern' |WHERE expr
如果给定SHOW
语句的语法包括部分,则为可以包含SQL 和通配符的字符串。该模式对于将语句输出限制为匹配值很有用。LIKE 'pattern'
'pattern'
%
_
一些SHOW
语句还接受一个WHERE
子句,该子句在指定要显示的行时提供了更大的灵活性。请参见“ SHOW语句的扩展”。
许多MySQL API(例如PHP)使您可以将SHOW
语句返回的结果与SELECT
;的结果集一样对待。有关更多信息,请参见连接器和API或您的API文档。此外,您可以在SQL中处理INFORMATION_SCHEMA
数据库表查询的结果,而这对SHOW
语句的结果则不容易。请参见INFORMATION_SCHEMA表。