SQL
Perform an UPSERT (Insert or Update) Operation
Efficiently insert new records or update existing ones based on a unique key conflict using SQL's UPSERT pattern, common in database management.
INSERT INTO products (product_id, product_name, price) VALUES (101, 'Laptop', 1200.00) ON CONFLICT (product_id) DO UPDATE SET product_name = EXCLUDED.product_name, price = EXCLUDED.price;
How it works: This SQL snippet demonstrates an UPSERT operation, which attempts to insert a new row into the `products` table. If a row with the same `product_id` (which must be a unique constraint) already exists, it updates the `product_name` and `price` of the existing record using the values provided for the insert, referred to as `EXCLUDED`.