如何导出表的建表语句?
mysql> show create table shop_admin;
| shop_admin | CREATE TABLE `shop_admin` (
`aid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pwd` varchar(40) NOT NULL default '',
`level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk |
| shop_admin | CREATE TABLE `shop_admin` (
`aid` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`pwd` varchar(40) NOT NULL default '',
`level` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk |