FIND YOUR NEXT FEW LINES
The snippet library.
Small, practical examples. Search by task or narrow things down below.
5 snippets foundClear filters
Combine results without duplicates
Merge compatible result sets with UNION.
UNION✓ Tested
Delete one matching row
Remove a selected record and inspect what remains.
DELETE✓ Tested
Insert a row with named columns
Add a record without relying on implicit column order.
INSERT✓ Tested
Test missing values with IS NULL
Find rows where an optional value is absent.
IS NULL✓ Tested
Update one matching row
Change a value with an explicit filter.
UPDATE✓ Tested