MySQL 语句级避免重复插入—— Insert Select Not Exist

INSERT INTO table(column1,column2,column3 ...columnN)
SELECT value1,value2,value3 ...valueN
FROM dual
WHERE NOT EXISTS(
      SELECT *
      FROM table
      WHERE value = ?
);

出自博客https://www.cnblogs.com/qq76211822/p/5260764.html；