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