(mysql.info.gz) SHOW COLUMNS

Info Catalog

(mysql.info.gz) SHOW COLLATION

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE DATABASE

 
 13.5.4.3 `SHOW COLUMNS' Syntax
 ..............................
 
      SHOW [FULL] COLUMNS FROM TBL_NAME [FROM DB_NAME] [LIKE 'PATTERN']
 
 `SHOW COLUMNS' lists the columns in a given table.  If the column types
 differ from what you expect them to be based on your `CREATE TABLE'
 statement, note that MySQL sometimes changes column types when you
 create or alter a table.  The conditions for which this occurs are
 described in  Silent column changes.
 
 The `FULL' keyword can be used from MySQL 3.23.32 on. It causes the
 output to include the privileges you have for each column.  As of MySQL
 4.1, `FULL' also causes any per-column comments to be displayed.
 
 You can use DB_NAME.TBL_NAME as an alternative to the `TBL_NAME FROM
 DB_NAME' syntax.  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'.
  `DESCRIBE' DESCRIBE.
 

Info Catalog

(mysql.info.gz) SHOW COLLATION

(mysql.info.gz) SHOW

(mysql.info.gz) SHOW CREATE DATABASE