How to use the show instruction in Mysql details _mysql

This article mainly introduces the main usage of the show command in MySQL database

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

B. show databases; --Displays the names of all databases in MySQL.

C. Show columns from table_name to database_name; or show columns from Database_name.table_name; --Displays the column names in the table.

D. Show grants for USER_NAME; --Displays the permissions of a user, displaying the results similar to the grant command.

E. Show index from TABLE_NAME; --Displays the index of the table.

F. Show status; --Displays information about some system-specific resources, such as the number of threads running.

G. Show variables; -Displays the name and value of the system variable.

H. Show Processlist; --Displays all the processes that are running on the system, which are currently executing queries.

I. Show table status; --Displays information for each table in the currently used or specified database. Information includes the most recent update times for table types and tables.

J. Show privileges; -Displays the different permissions that the server supports.

K. Show CREATE DATABASE database_name; --Displays whether the CREATE DATABASE statement is capable of creating the specified databases.

L. show CREATE TABLE table_name; --Displays whether the CREATE DATABASE statement is capable of creating the specified databases.

M. show Engies; --Displays the storage engine and default engine available after installation.

N. show InnoDB status; --Displays the status of the InnoDB storage engine.

O. Show logs; --Displays the log of the BDB storage engine.

P. Show warnings; --Displays errors, warnings, and notifications from the last executed statement.

Q. Show errors; --Displays only the errors generated by the last execution statement.

R. Show [storage] engines; --Displays the available storage engine and default engine after installation.