MySqlであるテーブルのデータを別のテーブルに挿入する実装コード
1000 ワード
web , , , , sql , sql , 。 mysql :
1. 2 , , :
INSERT INTO SELECT * FROM ;
insert into insertTest select * from insertTest2;
2. , :
INSERT INTO ( 1, 2, ...) SELECT 1, 2, ... FROM ;( )
insert into insertTest2(id) select id from insertTest2;
3. , :
INSERT INTO
( 1, 2, ...)
SELECT 1, 2, ...
FROM
WHERE not exists (select * from
where . = . );
1>. :
insert into insertTest2
(id,name)
select id,name
from insertTest
where not exists (select * from insertTest2
where insertTest2.id=insertTest.id);
2>. :
insert into insertTest
(id, name)
SELECT 100, 'liudehua'
FROM dual
WHERE not exists (select * from insertTest
where insertTest.id = 100);