[+/-]
SHOW AUTHORS
SyntaxSHOW BINARY LOGS
SyntaxSHOW BINLOG EVENTS
SyntaxSHOW CHARACTER SET
SyntaxSHOW COLLATION
SyntaxSHOW COLUMNS
SyntaxSHOW CONTRIBUTORS
SyntaxSHOW CREATE DATABASE
SyntaxSHOW CREATE EVENT
SyntaxSHOW CREATE FUNCTION
SyntaxSHOW CREATE PROCEDURE
SyntaxSHOW CREATE TABLE
SyntaxSHOW CREATE TRIGGER
SyntaxSHOW CREATE VIEW
SyntaxSHOW DATABASES
SyntaxSHOW ENGINE
SyntaxSHOW ENGINES
SyntaxSHOW ERRORS
SyntaxSHOW EVENTS
SyntaxSHOW FUNCTION CODE
SyntaxSHOW FUNCTION STATUS
SyntaxSHOW GRANTS
SyntaxSHOW INDEX
SyntaxSHOW INNODB STATUS
SyntaxSHOW MASTER STATUS
SyntaxSHOW OPEN TABLES
SyntaxSHOW PLUGINS
SyntaxSHOW PRIVILEGES
SyntaxSHOW PROCEDURE CODE
SyntaxSHOW PROCEDURE STATUS
SyntaxSHOW PROCESSLIST
SyntaxSHOW PROFILE
SyntaxSHOW PROFILES
SyntaxSHOW SLAVE HOSTS
SyntaxSHOW SLAVE STATUS
SyntaxSHOW STATUS
SyntaxSHOW TABLE STATUS
SyntaxSHOW TABLES
SyntaxSHOW TRIGGERS
SyntaxSHOW VARIABLES
SyntaxSHOW WARNINGS
Syntax
SHOW
has many forms that provide
information about databases, tables, columns, or status
information about the server. This section describes those
following:
SHOW AUTHORS SHOW CHARACTER SET [like_or_where
] SHOW COLLATION [like_or_where
] SHOW [FULL] COLUMNS FROMtbl_name
[FROMdb_name
] [like_or_where
] SHOW CONTRIBUTORS SHOW CREATE DATABASEdb_name
SHOW CREATE EVENTevent_name
SHOW CREATE FUNCTIONfunc_name
SHOW CREATE PROCEDUREproc_name
SHOW CREATE TABLEtbl_name
SHOW CREATE TRIGGERtrigger_name
SHOW CREATE VIEWview_name
SHOW DATABASES [like_or_where
] SHOW ENGINEengine_name
{STATUS | MUTEX} SHOW [STORAGE] ENGINES SHOW ERRORS [LIMIT [offset
,]row_count
] SHOW EVENTS SHOW FUNCTION CODEfunc_name
SHOW FUNCTION STATUS [like_or_where
] SHOW GRANTS FORuser
SHOW INDEX FROMtbl_name
[FROMdb_name
] SHOW OPEN TABLES [FROMdb_name
] [like_or_where
] SHOW INNODB STATUS SHOW PLUGINS SHOW PROCEDURE CODEproc_name
SHOW PROCEDURE STATUS [like_or_where
] SHOW PRIVILEGES SHOW [FULL] PROCESSLIST SHOW PROFILE [types
] [FOR QUERYn
] [OFFSETn
] [LIMITn
] SHOW PROFILES SHOW [GLOBAL | SESSION] STATUS [like_or_where
] SHOW TABLE STATUS [FROMdb_name
] [like_or_where
] SHOW [FULL] TABLES [FROMdb_name
] [like_or_where
] SHOW TRIGGERS [FROMdb_name
] [like_or_where
] SHOW [GLOBAL | SESSION] VARIABLES [like_or_where
] SHOW WARNINGS [LIMIT [offset
,]row_count
]like_or_where
: LIKE 'pattern
' | WHEREexpr
If the syntax for a given SHOW
statement includes a LIKE
'
part,
pattern
''
is a
string that can contain the SQL
“pattern
'%
” and
“_
” wildcard characters. The
pattern is useful for restricting statement output to matching
values.
Several SHOW
statements also accept
a WHERE
clause that provides more flexibility
in specifying which rows to display. See
Section 19.28, “Extensions to SHOW
Statements”.
Many MySQL APIs (such as PHP) allow you to treat the result
returned from a SHOW
statement as
you would a result set from a
SELECT
; see
Chapter 20, Connectors and APIs, or your API documentation for
more information. In addition, you can work in SQL with results
from queries on tables in the
INFORMATION_SCHEMA
database, which you cannot
easily do with results from SHOW
statements. See Chapter 19, INFORMATION_SCHEMA
Tables.
User Comments
A note on privileges
The privileges of the SHOW command appear to derive from those of SELECT.
If the user has SELECT privileges, then SHOW will be successful, and if not, will
be unsuccessful, with an error message, viz:
mysql> show tables in mysql;
ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'mysql'
Another way to look at this connection: SHOW is a shorthand for SELECT.
It appears that DESCRIBE is also a shorthand for SELECT and derives its
privileges from that command.
Add your own comment.