- 13.5.4 SHOW Syntax
- 13.5.4.1 SHOW AUTHORS Syntax
- 13.5.4.2 SHOW CHARACTER SET Syntax
- 13.5.4.3 SHOW COLLATION Syntax
- 13.5.4.4 SHOW COLUMNS Syntax
- 13.5.4.5 SHOW CONTRIBUTORS Syntax
- 13.5.4.6 SHOW CREATE DATABASE Syntax
- 13.5.4.7 SHOW CREATE EVENT
- 13.5.4.8 SHOW CREATE PROCEDURE and SHOW CREATE FUNCTION Syntax
- 13.5.4.9 SHOW CREATE TABLE Syntax
- 13.5.4.10 SHOW CREATE VIEW Syntax
- 13.5.4.11 SHOW DATABASES Syntax
- 13.5.4.12 SHOW ENGINE Syntax
- 13.5.4.13 SHOW ENGINES Syntax
- 13.5.4.14 SHOW ERRORS Syntax
- 13.5.4.15 SHOW EVENTS
- 13.5.4.16 SHOW GRANTS Syntax
- 13.5.4.17 SHOW INDEX Syntax
- 13.5.4.18 SHOW INNODB STATUS Syntax
- 13.5.4.19 SHOW OPEN TABLES Syntax
- 13.5.4.20 SHOW PLUGINS Syntax
- 13.5.4.21 SHOW PRIVILEGES Syntax
- 13.5.4.22 SHOW PROCEDURE CODE and SHOW FUNCTION CODE Syntax
- 13.5.4.23 SHOW PROCEDURE STATUS and SHOW FUNCTION STATUS Syntax
- 13.5.4.24 SHOW PROCESSLIST Syntax
- 13.5.4.25 SHOW SCHEDULER STATUS Syntax
- 13.5.4.26 SHOW STATUS Syntax
- 13.5.4.27 SHOW TABLE STATUS Syntax
- 13.5.4.28 SHOW TABLES Syntax
- 13.5.4.29 SHOW TRIGGERS Syntax
- 13.5.4.30 SHOW VARIABLES Syntax
- 13.5.4.31 SHOW WARNINGS Syntax
SHOW [FULL] COLUMNS FROMtbl_name[FROMdb_name] [LIKE 'pattern']
SHOW COLUMNS displays information about the
columns in a given table. It also works for views.
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
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
Section 13.3.1, “DESCRIBE Syntax”.
User Comments
When programming in PHP, ASP and the like I for example want to get the values from an "enum"
when querying like:
SHOW columns FROM table
if you load the result in an array it will look like this:
array([0],[Field],[1],[Type],[2],[Null],[3],[Key],[4],[Default],[5],[Extra])
Where the number, [x], gives the same value as the name, [name].
Good to know when getting the values for a enum field.
If you want to do this in PHP here is a good example:
http://se2.php.net/manual/en/function.mysql-fetch-field.php ->read user comments
Add your own comment.