show fields mysql command line

Solutions on MaxInterview for show fields mysql command line by the best coders in the world

showing results for - "show fields mysql command line"
Fabio
05 Mar 2019
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)