SQL: INSERT, UPDATE and DELETE

A short, tested SQL example for insert, update and delete. Copy it and adjust the names and paths for your project.

SQL

INSERT INTO users (name, email) VALUES ('Ann', 'ann@example.com');

UPDATE users SET active = false WHERE last_login < '2025-01-01';

DELETE FROM users WHERE id = 42;

Find it in Zest

Search for “sql insert, update and delete” in Zest and this example appears above the results, with other matches to choose from. Searches stay private.

More SQL examples

SELECT with WHERE and ORDER BY JOIN types GROUP BY and HAVING CREATE TABLE Create an index Common table expression (WITH)Window function: ROW_NUMBER Upsert (insert or update)

All SQL examples