Back

CRUD operations

CRUD stands for Create, Read, Update, Delete: the four basic things you do with data. In SQL they map to INSERT, SELECT, UPDATE, and DELETE. Always use WHERE with UPDATE and DELETE, or you'll change every row.

-- Create
INSERT INTO users (email, name) VALUES ('daniel@example.com', 'Daniel');

-- Read
SELECT * FROM users;
SELECT name FROM users WHERE id = 1;

-- Update
UPDATE users SET name = 'Dan' WHERE id = 1;

-- Delete
DELETE FROM users WHERE id = 1;

-- Return the new row after insert
INSERT INTO users (email) VALUES ('a@b.com') RETURNING *;

Roadmap