SHOW DATABASES [LIKE wild] or SHOW TABLES [FROM database] [LIKE wild] or SHOW COLUMNS FROM table [FROM database] [LIKE wild] or SHOW INDEX FROM table [FROM database] or SHOW STATUS or SHOW VARIABLES [LIKE wild]
Gives information about databases, tables or columns. If the LIKE
wild part is used the wild string is a normal SQL wildcard (with
% and _). FIELDS may be used as an alias for COLUMNS and
KEYS may be used as an alias for INDEXES.
STATUS gives status information from the server
like mysqladmin status). The output may differ from the following:
Uptime | Running_threads | Questions | Reloads | Open_tables
|
| 119 | 1 | 4 | 1 | 3 |
VARIABLES shows the values of the some of MySQL system variables. Most
of these variables can be changed by different options to mysqld!
Go to the first, previous, next, last section, table of contents.