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 databases in MySQL

shows 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 the processes for everyone, including passwords.

Show table status;
Explain: Displays information for each table in the currently used or specified database. Information includes the table type and the latest update time for the table

Show columns from table_name to database_name; or show columns from database_name.table_name; Explanation: Displays the column names in the 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 TABL E_name;
Explanation: Displaying the index of a table

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

Show variables
Explanation: Display system variable names and values
br> show privileges;
Explanation: Displays the different permissions supported by the server

Show CREATE DATABASE database_name
Explanation: Shows whether the CREATE DATABASE statement is capable of creating the specified databases

showing C reate table table_name;
Explanation: Displays whether 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
Explain: Display InnoDB storage engine State

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

Show warnings
Explain: error, warning, and notification resulting from the last executed statement

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