Query MySQL library/table related information

SHOW DATABASES                                //Lists the MySQL Server database. SHOW TABLES [from db_name]                    //Lists database data tables. SHOW CREATE TABLES tbl_name                    //Export data table structure. SHOW table status [from db_name]              //Lists data tables and table state information. Show COLUMNS from Tbl_name [from db_name]     //List table fields Show field from Tbl_name [from Db_name],describe tbl_name [Col_nam E]show full COLUMNS from tbl_name [from db_name]//list fields and details show field from Tbl_name [from db_name]//List field complete properties show INDE X from Tbl_name [from db_name]       //List table index. SHOW status                                  //lists the DB Server status. SHOW VARIABLES                               //Lists the MySQL system environment variables. SHOW processlist                             //Lists the execution commands. SHOW GRANTS for user                         //List A user right

Query MySQL library/table related information