mysql 중복되지 않는 데이터만 입력하는 쿼리
INSERT INTO Rss ( no, TITLE, LINK, PUBDATE, AUTHOR, DATE, ORD, CNAME, NAME, ID) SELECT (select * from (select ifnull(max(no) + 1,0) from rss) as no), #title#, #link#, sysdate(), #author#, sysdate(), (select * from (select ifnull(max(no) + 1,0) from rss) as ord), #cname#, 'SBCAdmin', 'sbcadmin' FROM DUAL WHERE NOT EXISTS (SELECT * FROM Rss WHERE link=#link#)
더보기