mysql資料庫多表同結構合併資料

萌新待開發發表於2020-10-31
MySql資料庫

 

insert into qmdb2.union2 select * from qmdb2.al_si_u 
union all select * from qmdb2.cr_fe
union all select * from qmdb2.fe_cr_al
union all select * from qmdb2.nb_zr
union all select * from qmdb2.o_fe
union all select * from qmdb2.o3
union all select * from qmdb2.si_u
union all select * from qmdb2.zr_h

 

相關文章