欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

SQL 向表累加数据行 mySQL java

程序员文章站 2022-04-27 15:28:48
...

SQL 向表追加数据行 mySQL java 好久没有不见了,困扰很久的问题在今天终于解决了,以前一直用 select * into? table1 from? table2 假如需要将table1 追加数据,却没有办法,只能用中间table3 select * into table3 from ( select * from table1 union all selec

SQL 向表追加数据行 mySQL java

好久没有不见了,困扰很久的问题在今天终于解决了,以前一直用
select * into? table1 from? table2

假如需要将table1 追加数据,却没有办法,只能用中间table3

select * into table3
from
(
select * from table1
union all
select * from table2
) data

--向表追加数据sql 语句
select * into #120 from
(
select 2 as source_type,D56.rkey,69 as fac from XXXXX d56
LEFT JOIN
(select * from data9287 where source_type =2) D9287 ON D9287.SOURCE_PTR=D56.RKEY
?where?? D9287.RKEY IS NULL AND tdate>='2013-09-01'
)AA
go
insert into data9287(source_type,source_ptr,plant_ptr)select source_type,rkey,fac from #120
go
Drop table #120


select * into #121 from
(
select 1 as source_type,D48.rkey,69 as fac from XXXXX D48
LEFT JOIN
(select * from data9287 where source_type =1) D9287 ON D9287.SOURCE_PTR=D48.RKEY
?where?? D9287.RKEY IS NULL AND tdate>='2013-09-01'
)AA
go
insert into data9287(source_type,source_ptr,plant_ptr)select source_type,rkey,fac from #121
go
Drop table #121