describe table_name;

這個(gè)命令用來(lái)顯示一個(gè)表格的結(jié)構(gòu)

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

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

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

| ID       | int(11)   | NO   | PRI | NULL    |       |

| userName | char(20)  | NO   |     | NULL    |       |

| password | char(20)  | NO   |     | NULL    |       |

| niName   | char(20)  | NO   |     | NULL    |       |

| sex      | char(10)  | NO   |     | NULL    |       |

| phone    | char(20)  | YES  |     | NULL    |       |

| address  | char(100) | YES  |     | NULL    |       |

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



和這個(gè)命令可以實(shí)現(xiàn)同樣效果的是：

show columns from table_name;





show create table table_name;//顯示某個(gè)表格被創(chuàng)建時(shí)所用的SQL語(yǔ)句



create table user  | CREATE TABLE `user` (

  `ID` int(11) NOT NULL,

  `userName` char(20) NOT NULL,

  `password` char(20) NOT NULL,

  `niName` char(20) NOT NULL,

  `sex` char(10) NOT NULL,

  `phone` char(20) DEFAULT NULL,

  `address` char(100) DEFAULT NULL,

  PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1 


  

mysql查表語(yǔ)句