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