MySQL displays table fields and comments.

MySQL displays table fields, comments, and other information. show databases // lists the MySQL Server database. Show tables [FROM db_name] // lists database data TABLES. Show table status [FROM db_name] // lists data tables and table status information. Show columns from tbl_name [FROM db_name] // lists the table fields show fields from tbl_name [FROM db_name] and DESCRIBE tbl_name [col_name]. Show full columns from tbl_name [FROM db_name] // lists FIELDS and details www.2cto.com show full fields from tbl_name [FROM db_name] // lists the complete attributes of FIELDS. show index from tbl_name [FROM db_name]/ /List table indexes. Show status // list the STATUS of the DB Server. Show variables // list MySQL system environment VARIABLES. Show processlist // list the execution commands. Show grants for user // list permissions of a user