GNU Info

(mysql.info)DESCRIBE

---

Prev: USE Up: Basic User Commands

---

Enter node , (file) or (file)node

`DESCRIBE' Syntax (Get Information About Columns)
-------------------------------------------------

     {DESCRIBE | DESC} tbl_name {col_name | wild}

`DESCRIBE' is a shortcut for `SHOW COLUMNS FROM'.  Note: SHOW DATABASE
INFO.

`DESCRIBE' provides information about a table's columns.  `col_name'
may be a column name or a string containing the SQL `%' and `_'
wild-card characters.

If the column types are different than you expect them to be based on a
`CREATE TABLE' statement, note that MySQL sometimes changes column
types.  Note: Silent column changes.

This statement is provided for Oracle compatibility.

The `SHOW' statement provides similar information.  Note: `SHOW'.