SQL 向表累加数据行 mySQL java
Jun 07, 2016 pm 04:14 PMSQL 向表追加数据行 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

Artikel Panas

Alat panas Tag

Artikel Panas

Tag artikel panas

Notepad++7.3.1
Editor kod yang mudah digunakan dan percuma

SublimeText3 versi Cina
Versi Cina, sangat mudah digunakan

Hantar Studio 13.0.1
Persekitaran pembangunan bersepadu PHP yang berkuasa

Dreamweaver CS6
Alat pembangunan web visual

SublimeText3 versi Mac
Perisian penyuntingan kod peringkat Tuhan (SublimeText3)

Topik panas

Bagaimana untuk membetulkan ralat mysql_native_password tidak dimuatkan pada MySQL 8.4
