存在的关联关系不重复添加sql
要避免重复插入,又不想折腾两回数据库连接操作
参考于:http://snowolf.iteye.com/blog/1568926
-
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
转自:https://blog.csdn.net/qq_41875147/article/details/81225801