mysql desc命令用于查看表結構,是DESCRIBE命令的簡寫形式。
mysql desc命令語法:
desc tablename
該命令會顯示表哪些信息呢?具體包括:
實例:
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 的資料整理,后續繼續補充相關資料,謝謝大家對本站的支持!
新聞熱點
疑難解答
圖片精選