第一条sql语句亲测,第二个没试过,一眼看上去,觉得第一个清楚简单明了,所以就没有看第二个了。
INSERT INTO table(column1,column2,column3 ...columnN)
SELECT value1,value2,value3 ...valueN
FROM dual
WHERE NOT EXISTS(
SELECT *
FROM table
WHERE value = ?
);
INSERT INTO content (
detail,
status,
beginTime,
endTime)
SELECT
@detail,
1,
NULL,
NULL
FROM DUAL
WHERE NOT EXISTS(
SELECT contentId
FROM content
WHERE detail=@detail);