mysql desc(DESCRIBE)命令实例讲解

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)