Show command in MySql

we use show command to describe or see the content of database

You can use the below command to check the complete list of syntax of show command

   help show

There are some command that describe show better

if you want to check the complete details of table like creation time and updation time then use the following command

 show table status where name = “yourTableName”\G;

if you want to see the schema of your table then use below command

 show create table yourTableName;

if you want to check details of every column of your table then use the following command

show columns from yourTableName;                   

                 or                                      

  describe  yourTableName;     

if you want to check how many connection are used in mysql or connection details then use the below command

show full processlist;