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