SQL: INSERT INTO SELECT & SELECT NOT IN

回复
头像
Mia2014
帖子: 1805
注册时间: 周三 12月 25, 2013 8:24 pm

SQL: INSERT INTO SELECT & SELECT NOT IN

帖子 Mia2014 » 周一 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`));

回复