MySQL also comes with a full-featured list of SHOW statements to obtain information about all aspects of the server, its databases, and its tables.
Here’s a quick list:
- The SHOW DATABASES statement displays a list of databases on the server.
- The SHOW TABLES statement displays a list of tables in a database.
- The DESCRIBE statement displays the structure of a table.
- The SHOW CREATE TABLE statement retrieves the SQL statements originally used to create the table.
- The SHOW INDEX statement displays a list of table indexes.
- The SHOW ENGINES statement retrieves a list of available storage engines.
- The SHOW PROCESSLIST statement displays a list of active connections to the server, as well as what each one is doing.
- The SHOW ERRORS and SHOW WARNINGS statements display a list of errors and warnings generated by the server.
- The SHOW STATUS statement displays live server status (including information on server uptime, number of queries processed, and number of connections).
- The SHOW TABLE STATUS statement displays detailed information on the tables in a database (including information on the table type, the number of rows, the date and time of the last table update, and the lengths of indexes and rows).
- The SHOW CHARACTER SET statement displays a list of available character sets.