describe
]Podporované v MySQL
Syntax
{DESCRIBE | DESC} tbl_name [col_name | wild]
Popis
Príkaz jazyka SQL
DESCRIBE zobrazí informácie o stĺpcoch danej tabuľky. Je to skrátený príkaz pre SHOW COLUMNS FROM.
Príklad
mysql> DESCRIBE City;
+------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+----------------+
| Id | int(11) | | PRI | NULL | auto_increment |
| Name | char(35) | | | | |
| Country | char(3) | | UNI | | |
| District | char(20) | YES | MUL | | |
| Population | int(11) | | | 0 | |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
+------------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+----------------+
| Id | int(11) | | PRI | NULL | auto_increment |
| Name | char(35) | | | | |
| Country | char(3) | | UNI | | |
| District | char(20) | YES | MUL | | |
| Population | int(11) | | | 0 | |
+------------+----------+------+-----+---------+----------------+
5 rows in set (0.00 sec)
]
Martin Kasman, M Software
Smreková 3095/23
Email: martin@kasman.sk
Telefón: 0908 270 294