describe table_name;

這個命令用來顯示一個表格的結構

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

| 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    |       |

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



和這個命令可以實現同樣效果的是：

show columns from table_name;





show create table table_name;//顯示某個表格被創建時所用的SQL語句



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查表語句