如果我启动这个插入两次

Question

如果我启动此插入两次，它将向我添加重复的产品。如果发生了变化，我如何添加?

INSERT INTO db1 ("Drink") VALUES
('Cola'),
('Rom'),
('Sprite'),
('Fanta'),
('Vodka');

Answer 1

INSERT INTO db1 ("Drink")
select
drinks.drink
from
(
VALUES
('Cola'),
('Rom'),
('Sprite'),
('Fanta'),
('Vodka')
)
as drinks(drink)
where not exists (select 1 from db1 where db1.drink=drinks.drink)