对于普通的 INSERT 插入,如果想要保证不插入重复记录,我们只有对某个字段创建唯一约束实现
要是没有唯一约束怎么实现了?
INSERT INTO table(field1, field2, fieldn)
SELECT 'field1', 'field2', 'fieldn' FROM DUAL
WHERE NOT EXISTS(SELECT field FROM table WHERE field = ?)
对于普通的 INSERT 插入,如果想要保证不插入重复记录,我们只有对某个字段创建唯一约束实现
要是没有唯一约束怎么实现了?
INSERT INTO table(field1, field2, fieldn)
SELECT 'field1', 'field2', 'fieldn' FROM DUAL
WHERE NOT EXISTS(SELECT field FROM table WHERE field = ?)