|
show create table tablename
这个命令就行.
mysql> show create table users;
+-------+-
| Table | Create Table |
+-------++
| users | CREATE TABLE `users` (
`user` varchar(16) NOT NULL default '',
`passwd` varchar(16) NOT NULL default '',
`ugroup` varchar(16) default NULL,
`email` varchar(64) default '',
`phone` varchar(64) default '',
`status` char(1) NOT NULL default '1',
`truename` varchar(20) default NULL,
`mobile` varchar(21) NOT NULL default '0',
`error_cnt` int(5) unsigned NOT NULL default '0',
PRIMARY KEY (`user`)
) TYPE=MyISAM |
+-------++
1 row in set (0.00 sec)
mysql>
|