Specifications

SHOW COLUMNS FROM table Lists all the columns in a particular table
[FROM database] [LIKE column] from the database currently in use, or from
the database specified, optionally with col-
umn names like column. You might use SHOW
FIELDS instead of SHOW COLUMNS.
SHOW INDEX FROM table Shows details of all the indexes on a
[FROM database] particular table from the database currently
in use, or from the database called
database
if specified. You might use SHOW KEYS
instead.
SHOW STATUS [LIKE status_item] Gives information about a number of system
items, such as the number of threads run-
ning. The
LIKE clause is used to match
against the names of these items, so, for
example, ‘Thread%’ matches the items
‘Threads_cached’, ‘Threads_connected’,
and ‘Threads_running’.
SHOW VARIABLES [LIKE variable_name] Displays the names and values of the
MySQL system variables, such as the ver-
sion number. The LIKE clause can be used
to match against these in a fashion similar
to SHOW STATUS.
SHOW [FULL] PROCESSLIST Displays all the running processes in the
system, that is, the queries that are currently
being executed. Most users will see their
own threads but if they have the PROCESS
privilege, they can see everybody’s
processes—including passwords if these are
in queries. The queries are truncated to 100
characters by default. Using the optional
keyword FULL displays the full queries.
SHOW TABLE STATUS Displays information about each of the
[FROM database] [LIKE database] tables in the database currently being used,
or the database called database if it is spec-
ified, optionally with a wildcard match. This
information includes the table type and
when each table was last updated.
Using MySQL
P
ART II
256
TABLE 11.6 Continued
Variation Description
14 7842 CH11 3/6/01 3:35 PM Page 256