mysql查表语句

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