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:

  1. The SHOW DATABASES statement displays a list of databases on the server.
  2. The SHOW TABLES statement displays a list of tables in a database.
  3. The DESCRIBE statement displays the structure of a table.
  4. The SHOW CREATE TABLE statement retrieves the SQL statements originally used to create the table.
  5. The SHOW INDEX statement displays a list of table indexes.
  6. The SHOW ENGINES statement retrieves a list of available storage engines.
  7. The SHOW PROCESSLIST statement displays a list of active connections to the server, as well as what each one is doing.
  8. The SHOW ERRORS and SHOW WARNINGS statements display a list of errors and warnings generated by the server.
  9. The SHOW STATUS statement displays live server status (including information on server uptime, number of queries processed, and number of connections).
  10. 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).
  11. The SHOW CHARACTER SET statement displays a list of available character sets.
JSC0d3's Logo
About JSC0d3

JSC0d3 is an entrepreneur, online marketer, and an employee of an IT company. When not building websites, creating content, or helping customers improve their online business, spend time with their wife and two beautiful children. Although he still feels new in WordPress, he enjoys sharing what he has learned with all of you! If you want to get in touch with him, you can do this through this website.

On the same idea

Posted by | June 22, 2014

The purpose of nomalization is to reduce redundancy in a database and also to make it more flexible Database normalization is a database schema...

Posted by | June 16, 2014

MySQL select random records using RAND function
MySQL does not have any built-in statement to select random records from a database table In order to...

Posted by | June 16, 2014

MySQL comes with more than 100 built-in functions to help perform calculations and process the records in a result set These functions can be used...

Previous PostBackNext Post

Leave here an impression