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.

Source of Information : MCGraw Hill - SQL the Complete Reference 3rd Edition


Subscribe to Developer Techno ?
Enter your email address:

Delivered by FeedBurner