如果每个表相同,用union all 将个别的数据合并 inert into新表就行了select * from
(
select * from 20140101_name
union all
select * from 20140102_name
......
)
insert into newtable或者先创建和原表相同的结果,在新建一个自动编号的列,原别的id保存为tableid列中,然后
insert into newtable (col1,col2,....)
select * from 20140101_name
union all
select * from 20140102_name
....
(
select * from 20140101_name
union all
select * from 20140102_name
......
)
insert into newtable或者先创建和原表相同的结果,在新建一个自动编号的列,原别的id保存为tableid列中,然后
insert into newtable (col1,col2,....)
select * from 20140101_name
union all
select * from 20140102_name
....
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货