MySQL开发者SQL权威指南-附录(14)
时间：2025-07-07
MySQL开发者SQL权威指南的附录文档
SHOW CREATE VIEW <table specification>
Show Databases语句
<show databases statement> ::=
SHOW DATABASES [ LIKE <alphanumeric literal> ]
Show Engine语句
<show engine statement> ::=
SHOW ENGINE <engine namer> { LOGS | STATUS }
Show Engines语句
<show engines statement> ::=
SHOW [ STORAGE ] ENGINES
Show Errors语句
<show errors statement> ::=
SHOW ERRORS
[ LIMIT [ <fetch offset> , ] <fetch number of rows> ] |SHOW [ COUNT(*) ] ERRORS
Show Events语句
<show events statement> ::=
SHOW EVENTS [ FROM <database name> ]
[ LIKE <alphanumeric literal> ]
Show Function语句
<show function status statement> ::=
SHOW FUNCTION STATUS [ LIKE <alphanumeric literal> ]
Show Grants 语句
<show grants statement> ::=
SHOW ACCOUNTS [ FOR <user name> ]
Show Index语句
<show index statement> ::=
SHOW { INDEX | KEY } { FROM | IN }
<table specification> [ { FROM | IN }<database name> ]
Show Privileges语句
<show privileges statement> ::=
SHOW PRIVILEGES
Show Procedure Status语句
<show procedure status statement> ::=
SHOW PROCEDURE STATUS [ LIKE <alphanumeric literal> ]
Show Table Types语句
<show table types statement> ::=
SHOW TABLE TYPES
MySQL开发者SQL权威指南-附录(14).doc
将本文的Word文档下载到电脑
上一篇：农光互补项目简介与发展前景
