(mysql.info) show-columns
Info Catalog
(mysql.info) show-collation
(mysql.info) show
(mysql.info) show-create-database
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