Help and Show Commands in MySQL

In MySQL we have to use many commands.  Some commands use to show statement.

These commands provide general information related to our database.  The output from show table contains a single column of table names.  This statement also lists any views in the database.
Such as follows in given commands in the given figures :

mysql> use db_name;
mysql> show databases;
mysql> show databases like 'ba%' ;

Show Statement :Show Tables lists the non-TEMPORARY tables in a given database.

mysql> show tables;

Describe : This command shows table functionality.

mysql> describe table_name;
mysql> select user(), now(), version(), database();

mysql> show tables from db_name like '__ab%'
mysql> show columns from products;
mysql> show grants for root@localhost;

mysql> show index from products;
mysql> show index from products from mcn;
mysql show processlist;

Status : Get status information from the server.

mysql> show status ;

 mysql> show table status from mcn;

Variables : Show variables shows the values of MySQL system variables. Show variable displays the values that are used for new connections to MySQL.

mysql> show variables;