Usage of the show command in the MySQL database

This document describes how to use the show command in a MySQL database:

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

B. Show databases; -- display 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; -- display the name and value of the system variable.

H. Show processlist; -- display 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; -- display different permissions supported by the server.

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 engies; -- 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 [Storage] engines; -- display available storage engines and default engines after installation.