MySQL SHOW Statement Daquan

The common MySQL show commands are as follows:

1, show databases; Show all databases in MySQL

2, show tables [from databases]; Displays the names of all tables in the current database

3, Show columns from tables; Displays the names of the columns in the table, same as DESC table_name

4, show [Full] processlist; All processes that are running

5, show grants for user_name; Show permissions for a user

6. Show [Global] |    Session] variables [like '%keyword% ']; Display the name and value of a system variable

7. Show [Global |       Session] status [like '%keyword ']; Providing Server status information

8, show index from table_name [from db_name]; Index of the display table

9, show privileges; Display the permissions supported by the server

10. Show table status [from db_name] like '%keyword% '; Displays information about the database or each table that specifies databases, including the table type, creation time, and last updated time of the table

11, show CREATE DATABASE database_name; Show CREATE DATABASE statement

12, show create TABLE table_name; Show statements that create tables

13, show InnoDB status; Show the status of the storage engine

14, show logs; Displaying logs for the BDB storage engine

15, show warnings; Displays the error messages, warnings, and notifications generated by the last statement executed

16, show errors; Displays the error generated by the last statement executed

17, show Charector set [like '%part% ']; Show available character sets, like to match the Charector field of a table

18, show collation [like '%latin1% ']; Used to show how all available character sets are sorted, like to match collation fields in a table

19, show full columns from tab_name [like '%user% ']; Displays the information for each column in a table, the full keyword causes the output to contain the permissions you have, and contains the comments for each column, like to match the list

20, show engine InnoDB logs; Display log or status information for the storage engine

21, show [storage] engine; Displays status information for the storage engine. You can see if a storage engine is supported, and what the default engine is.

22, show grants;

Show grants for username;

Show grants for Current_User;

Show grants for Current_User ();

23, show open tables [from db_name] [like '%keyword% ']; Lists the non-temporary tables that are currently open in the table cache.

24, show triggers [from db_name] [like '%keyword% '];  Lists the trigger programs currently defined by the MySQL server. The expression to be matched (epx) of the LIKE clause is compared to the name of the table on which the trigger was defined, rather than the name of the triggering program.

25, show create PROCEDURE sp_name; Show details for a stored procedure

MySQL SHOW Statement Daquan