查看一个表的建表语句 show create table [表名];

例如：显示goods表的建表语句 show create table goods;

结果

CREATE TABLE `goods` (

  `goods_id` mediumint(8) unsigned NOT NULL auto_increment,

  `cat_id` smallint(5) unsigned NOT NULL default '0',

  `goods_sn` varchar(60) NOT NULL default '',

  `goods_name` varchar(120) NOT NULL default '',

  `click_count` int(10) unsigned NOT NULL default '0',

  `goods_number` smallint(5) unsigned NOT NULL default '0',

  `market_price` decimal(10,2) unsigned NOT NULL default '0.00',

  `shop_price` decimal(10,2) unsigned NOT NULL default '0.00',

  `add_time` int(10) unsigned NOT NULL default '0',

  `is_best` tinyint(1) unsigned NOT NULL default '0',

  `is_new` tinyint(1) unsigned NOT NULL default '0',

  `is_hot` tinyint(1) unsigned NOT NULL default '0',

  PRIMARY KEY  (`goods_id`)

) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

#把另外一个库的表的内容导入到现在的一个表中(把shop库中的goods表内容导入到test库中的goods表)

insert into test.goods

select goods_id,cat_id,goods_sn,goods_name,click_count,goods_number,market_price,shop_price,add_time,is_best,is_new,is_hot 

from shop.goods;