小松鼠solo

我常用的两个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`));