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