SQL: INSERT INTO SELECT & SELECT NOT IN
发表于 : 周一 6月 16, 2014 1:40 pm
我常用的两个SQL语句:
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;
SELECT column_name1 FROM table1
WHERE column_name1 NOT IN
(SELECT column_name2 FROM table2)
例子程序:
INSERT INTO `mails`
(`Email_ID`)
(SELECT `ID`
FROM `contact_info` where `ID` NOT IN (SELECT `Email_ID` FROM `mails`));
INSERT INTO table2
(column_name(s))
SELECT column_name(s)
FROM table1;
SELECT column_name1 FROM table1
WHERE column_name1 NOT IN
(SELECT column_name2 FROM table2)
例子程序:
INSERT INTO `mails`
(`Email_ID`)
(SELECT `ID`
FROM `contact_info` where `ID` NOT IN (SELECT `Email_ID` FROM `mails`));