Mysql show columns and other show usage

Show DATABASES: lists the DATABASES on the mysql Server. Show tables [FROM db_name]: Lists TABLES in a database. Show table status [FROM db_name]: lists the TABLE information of a database. Show columns from tbl_name [FROM db_name]: lists the column information of a table, which is the same as show fields from tbl_name [FROM db_name] and DESCRIBE tbl_name [col_name]. Show full columns from tbl_name [FROM db_name]: list the column information of the table. The details are the same as show full fields from tbl_name [FROM db_name]. Www.2cto.com show index from tbl_name [FROM db_name]: lists the INDEX information of a table. Show status: lists the STATUS information of the Server. Show variables: List MySQL system parameter values show processlist: view the current mysql Query Process show grants for user: List user authorization commands