(mysql.info) show-columns

 
 13.5.4.3 `SHOW COLUMNS' Syntax
 ..............................
 
      SHOW [FULL] COLUMNS FROM TBL_NAME [FROM DB_NAME] [LIKE 'PATTERN']
 
 `SHOW COLUMNS' displays information about the columns in a given table.
 It also works for views as of MySQL 5.0.1.
 
 If the data types differ from what you expect them to be based on your
 `CREATE TABLE' statement, note that MySQL sometimes changes data types
 when you create or alter a table. The conditions for which this occurs
 are described in  silent-column-changes.
 
 The `FULL' keyword causes the output to include the privileges you have
 as well as any per-column comments for each column.
 
 You can use DB_NAME.TBL_NAME as an alternative to the `TBL_NAME FROM
 DB_NAME' syntax. In other words, these two statements are equivalent:
 
      mysql> SHOW COLUMNS FROM mytable FROM mydb;
      mysql> SHOW COLUMNS FROM mydb.mytable;
 
 `SHOW FIELDS' is a synonym for `SHOW COLUMNS'. You can also list a
 table's columns with the `mysqlshow DB_NAME TBL_NAME' command.
 
 The `DESCRIBE' statement provides information similar to `SHOW
 COLUMNS'. See  describe.

Info Catalog

(mysql.info) show-collation

(mysql.info) show

(mysql.info) show-create-database

automatically generated byinfo2html