Database

Common Queries

Basic CRUD

-- Select
SELECT * FROM users WHERE active = true ORDER BY created_at DESC;

-- Insert
INSERT INTO products (name, price, category) VALUES ('Widget', 19.99, 'Tools');

-- Update
UPDATE inventory SET quantity = quantity - 1 WHERE id = 123;

-- Delete
DELETE FROM pending_users WHERE created_at < NOW() - INTERVAL '7 days';