A. show tables or show tables from database_name;-displays the names of all tables in the current MySQL database.
B. show databases;-displays the names of all databases in MySQL.
C. show columns from table_name from database_name; or show columns from database_name.table_name;-display the column name in the table.
D. show grants for user_name;-displays the permissions of a user. The result is similar to the grant command.
E. show index from table_name;-displays the table index.
F. show status;-displays information about specific system resources, such as the number of running threads.
G. show variables;-displays the name and value of the system variable.
H. show processlist;-displays all processes running in the system, that is, the query being executed.
I. show table status;-displays 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.
J. show privileges;-different permissions supported by the server are displayed.
K. show create database database_name;-displays whether the create database statement can create a specified database.
L. show create table table_name;-displays whether the create database statement can create a specified database.
M. show engines;-displays available storage engines and default engines after installation.
N. show innodb status;-displays the innoDB Storage engine status.
O. show logs;-displays the logs of the BDB storage engine.
P. show warnings;-displays errors, warnings, and notifications generated by the last executed statement.
Q. show errors;-only displays errors generated by the last statement.
R. show [s × age] engines;-displays available storage engines and default engines after installation.