如:
db1
tab1
name age high ...
a 12 175 ...
b 13 160 ...
c 18 165 ...
tabn ..
db2
tab1
name age high ...
a 15 180 ...
b 13 160 ...
d 25 175 ...
tabn ..
合并后
db
tab
name age high ...
a 15 180 ...
b 13 160 ...
c 18 165 ...
d 25 175 ...
tabn ..
数据里的每个表都这样的合并,语句怎么写?
我试的这样不行 insert into db as select * from (select * from db1 union all select * from db2) as tmp;
求助:多个MYSQL数据合并,每个数据库表一样,表属性一样
-
- 帖子: 5
- 注册时间: 2014-04-20 11:25
- 系统: Ubuntu14.04