mysql desc命令用於查看錶結構，是DESCRIBE命令的簡寫形式。

mysql desc命令語法：

desc tablename

該命令會顯示錶哪些資訊呢？具體包括：

欄位名稱(Field)

欄位型別(Type)

欄位是否為null

欄位是否為主鍵(key)

欄位的預設值(default)

Extra

例項：

mysql> CREATE TABLE employee (

-> ID INT(2) auto_increment primary key,

-> First_name VARCHAR(20),

-> Last_name VARCHAR(30),

-> Start_date DATE,

-> Salary int(6),

-> city VARCHAR(20),

-> description VARCHAR(20)

-> );

Query OK, 0 rows affected (0.02 sec)

mysql>

mysql> desc employee;

+-------------+-------------+------+-----+---------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------------+-------------+------+-----+---------+----------------+

| ID | int(2) | NO | PRI | NULL | auto_increment |

| First_name | varchar(20) | YES | | NULL | |

| Last_name | varchar(30) | YES | | NULL | |

| Start_date | date | YES | | NULL | |

| Salary | int(6) | YES | | NULL | |

| city | varchar(20) | YES | | NULL | |

| description | varchar(20) | YES | | NULL | |

+-------------+-------------+------+-----+---------+----------------+

7 rows in set (0.00 sec)

以上就是對mysql desc 的資料整理