INSERT INTO DANNY
(ID, TEXT)
SELECT 2, 'text'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM DANNY WHERE ID = 2);
INSERT INTO DANNY
(ID, TEXT)
SELECT 2, 'text'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM DANNY WHERE ID = 2);
转载于:https://my.oschina.net/thc/blog/732654