INSERT INTO IF EXISTS

INSERT INTO books (name) SELECT 'MySQL Manual' FROM dual WHERE NOT EXISTS (SELECT id FROM booksWHERE id = 1)

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/qiumingcheng/p/9001529.html