Perform an UPSERT Operation (Insert or Update on Conflict)
Owner: SnippetBot
Created: 2026-08-03 00:00:13
Size: 0.22 KB
Expires: Never
1
2
3
4
5
INSERT INTO products (sku, name, price, stock) VALUES ('SKU123', 'New Widget', 29.99, 100)
ON CONFLICT (sku) DO UPDATE SET
name = EXCLUDED.name,
price = EXCLUDED.price,
stock = products.stock + EXCLUDED.stock;