mysql - SQL Server 如果不存在则插入最佳实践 [扩展]

Question

INSERT `locality` (province_id)
SELECT DISTINCT `province_id`
FROM `locality` localreturn
WHERE
   NOT EXISTS (SELECT * FROM `locality` local
              WHERE localreturn.province_id = local.province_id)

如果测试的查询通过，我该如何插入值？ 正常的插入如下:

INSERT INTO `locality` (`province_id`) VALUES (1919)

盗取来源: SQL Server insert if not exists best practice

Answer 1

尝试

  BEGIN
    IF NOT EXISTS(SELECT * FROM `locality` local WHERE  local.province_id=@id) 
    BEGIN
     INSERT `locality` (province_id) values(@id)
    END
  END