MySQL tutorial: MySQL show command

Show tables or show tables from database_name;
Explanation: Displays the names of all tables in the current database

show databases;
Explanation: Displays the names of all the databases in MySQL

Show Processlist;
Explanation: Displays all processes running on the system, which are currently executing queries. Most users can view
Their own processes, but if they have process permissions, they can view all of the processes, including passwords.

Show table status;
Explanation: Displays information about each table in the currently used or specified database. Information includes the latest update times for table types and tables

Show columns from table_name to database_name; or show columns from Database_name.table_name;
Explanation: Display column names in a table

Show grants for User_name@localhost;
Explanation: Displays the permissions of a user, displaying the results similar to the grant command

Show index from TABLE_NAME;
Explanation: Displays the index of the table

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

Show variables;
Explanation: Displays the name and value of the system variable

Show privileges;
Explanation: Displays the different permissions supported by the server

Show CREATE DATABASE database_name;
Explanation: Shows if the CREATE DATABASE statement can create the specified databases

Show CREATE TABLE table_name;
Explanation: Shows if the CREATE DATABASE statement can create the specified databases

Show Engies;
Explanation: Displays the storage engine and default engine available after installation.

Show InnoDB status;
Explanation: Displays the status of the InnoDB storage engine

Show logs;
Explanation: Displays the log of the BDB storage engine

Show warnings;
Explanation: Displays errors, warnings, and notifications from the last executed statement

Show errors;
Explanation: Displays only the errors generated by the last execution statement