1
2
3
4
5 mysql> DESCRIBE orders;
6+----------------+-------------+------+-----+---------+-------+
7| Field | Type | Null | Key | Default | Extra |
8+----------------+-------------+------+-----+---------+-------+
9| orderNumber | int(11) | NO | PRI | NULL | |
10| orderDate | date | NO | | NULL | |
11| requiredDate | date | NO | | NULL | |
12| shippedDate | date | YES | | NULL | |
13| status | varchar(15) | NO | | NULL | |
14| comments | text | YES | | NULL | |
15| customerNumber | int(11) | NO | MUL | NULL | |
16+----------------+-------------+------+-----+---------+-------+
177 rows in set (0.01 sec)
18Code language: SQL (Structured Query Language) (sql)