Database
mysql 중복되지 않는 데이터만 입력하는 쿼리
휴렛
2013. 11. 19. 14:01
반응형
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#)
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#)
반응형