Detailed analysis of the usage of the Show command

Usage of the Show command:

1. show tables or show tables from database_name; -- Displays the names of all tables in the current database.

2. show databases; -- Display the names of all databases in mysql.

3. show columns from table_name from database_name; or show columns from database_name.table_name; -- display the column names in the table.

4. show grants for user_name; -- Display a user's permissions, showing results similar to the grant command.

5. show index from table_name; -- Display the index of the table.

6. show status; -- Display information about some system-specific resources, such as the number of threads that are running.

7. show variables; -- Display the name and value of the system variable.

8. show processlist; -- Shows all the processes that are running on the system, which is the currently executing query. Most users can view their own processes, but if they have process privileges, they can view everyone's processes, including passwords.

9. show table status; -- Display information about each table in the currently used or specified database. The information includes the table type and the latest update time of the table.

10. show privileges; -- Shows the different permissions supported by the server.

11. show create database database_name; -- Shows whether the create database statement can create the specified database.

12. show create table table_name; -- Shows whether the create database statement can create the specified database.

13. show engies; -- Shows the storage engine and default engine available after installation.

14. show innodb status; -- Display the status of the innoDB storage engine.

15. show logs; -- Display the logs of the BDB storage engine.

16. show warnings; -- Display the errors, warnings, and notifications generated by the last executed statement.

17. show errors; -- Only the errors generated by the last execution statement are displayed.

18. show [storage] engines; --Displays the available storage engine and default engine after installation.

This article is taken from: I love computer technology forum (http://bbs.520dn.com) Please refer to the detailed source: http://bbs.520dn.com/forum.php?mod=viewthread&tid= 11011