본문 바로가기

Database

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#)

 

반응형