SQL INSERT INTO 不重複 – jashliao部落格

SQL INSERT INTO 不重複

資料來源:http://blog.csdn.net/pandajava/article/details/45667001

語法:

INSERT INTO 表01 (欄位01,欄位02) SELECT 填入值01,填入值02 FROM 虛擬表名稱 WHERE NOT EXISTS(SELECT 欄位01 FROM 表01 WHERE 欄位01 = 填入值01 AND 欄位02 = 填入值02 );

ex:
    INSERT INTO area_detail (area_id,door_id,state) SELECT 4,1,1 FROM DUAL WHERE NOT EXISTS(SELECT area_id FROM area_detail WHERE area_id = 4 AND door_id = 1);

PS 虛擬表 不用真實存在