mysql数据库所有表合并_mysql数据库如何将表合并我从数据库中倒出表导出后是这样的b 爱问知识人...

我从数据库中倒出表导出后是这样的

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE `sg` (

`username` varchar(15) NOT NULL COMMENT '帐号',

`p

我从数据库中倒出表导出后是这样的

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; CREATE TABLE `sg` (

`username` varchar(15) NOT NULL COMMENT '帐号',

`password` varchar(20) NOT NULL COMMENT '密码',

`name` varchar(7) character set gb2312 NOT NULL COMMENT '角色名',

`city` varchar(7) character set gb2312 NOT NULL COMMENT '城池名',

`people` int(7) NOT NULL COMMENT '人口',

`countries` varchar(2) character set gb2312 NOT NULL COMMENT '国家',

`family` varchar(7) character set gb2312 NOT NULL COMMENT '家族',

`fame` int(7) NOT NULL COMMENT '声望',

`ranking` int(7) NOT NULL COMMENT '排名',

`curtilage` varchar(7) character set gb2312 NOT NULL COMMENT '官职',

`gold` int(7) NOT NULL COMMENT '金币',

`wentao` varchar(5) character set gb2312 NOT NULL COMMENT '文涛',

`wulue` varchar(5) character set gb2312 NOT NULL COMMENT '武略',

`wood` int(7) NOT NULL COMMENT '木头',

`iron` int(7) NOT NULL COMMENT '铁',

`stone` int(7) NOT NULL COMMENT '石头',

`food` int(7) NOT NULL COMMENT '食物',

`junying` int(2) NOT NULL COMMENT '军营',

`jumin` int(2) NOT NULL COMMENT '居民',

`yiguan` int(2) NOT NULL COMMENT '驿馆',

`shuyuan` int(2) NOT NULL COMMENT '书院',

`cangku` int(2) NOT NULL COMMENT '仓库',

`miku` int(2) NOT NULL COMMENT '秘库',

`chengfang` int(2) NOT NULL COMMENT '城防',

`gongjiangpu` int(2) NOT NULL COMMENT '工匠铺',

`muliaofang` int(2) NOT NULL COMMENT '木料坊',

`yelianfang` int(2) NOT NULL COMMENT '冶炼坊',

`shiliaofang` int(2) NOT NULL COMMENT '石料坊',

`mofang` int(2) NOT NULL COMMENT '磨坊',

`tuohuanying` int(2) NOT NULL COMMENT '拓荒营',

`gongbu` int(2) NOT NULL COMMENT '工部',

`guanfu` int(2) NOT NULL COMMENT '官府'

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `keji` (

`citan` int(2) NOT NULL COMMENT '刺探',

`tongshuai` int(2) NOT NULL COMMENT '统帅',

`hujia` int(2) NOT NULL COMMENT '护甲',

`liren` int(2) NOT NULL COMMENT '利刃',

`shenjian` int(2) NOT NULL COMMENT '神箭',

`yunsong` int(2) NOT NULL COMMENT '运送',

`fuzhong` int(2) NOT NULL COMMENT '负重',

`zhucheng` int(2) NOT NULL COMMENT '筑城',

`kuangben` int(2) NOT NULL COMMENT '狂奔',

`jibu` int(2) NOT NULL COMMENT '急步'

) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE `war` (

`liangcaobing` int(5) NOT NULL COMMENT '粮草兵',

`yunshuche` int(5) NOT NULL COMMENT '运输车',

`zhengchabing` int(5) NOT NULL COMMENT '侦查兵',

`tuohuangbudui` int(5) NOT NULL COMMENT '托慌部队',

`qiangdunbing` int(5) NOT NULL COMMENT '枪盾兵',

`qiangnubing` int(5) NOT NULL COMMENT '强弩兵',

`changqiangbing` int(5) NOT NULL COMMENT '长枪兵',

`gongjianbing` int(5) NOT NULL COMMENT '弓箭兵',

`qiqiangzhanjiang` int(5) NOT NULL COMMENT '骑枪战将',

`qishezhanjiang` int(5) NOT NULL COMMENT '骑射战将',

`xianjing` int(5) NOT NULL COMMENT '陷阱',

`gaojixianjing` int(5) NOT NULL COMMENT '高级陷阱',

`jianta` int(5) NOT NULL COMMENT '箭塔',

`gaojijianta` int(5) NOT NULL COMMENT '高级箭塔',

`gunshi` int(5) NOT NULL COMMENT '滚石',

`leimu` int(5) NOT NULL COMMENT '檑木',

`huojian` int(5) NOT NULL COMMENT '火箭',

`jiaoche` int(5) NOT NULL COMMENT '绞车'

) ENGINE=InnoDB DEFAULT CHARSET=latin1;  如何把三个表 合并成一个表呢？

展开

全部