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
• 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
|
0 comments
Post a Comment