Insert single or batch rows, update with conditions, delete rows, and use ON DUPLICATE KEY UPDATE.
INSERT, UPDATE, DELETE
-- INSERT
INSERT INTO users (name, email, age)
VALUES ('Alice', 'alice@example.com', 28);
INSERT INTO users (name, email) VALUES
('Bob', 'bob@example.com'),
('Carol', 'carol@example.com');
-- INSERT or update on duplicate key
INSERT INTO users (email, name)
VALUES ('alice@example.com', 'Alice Updated')
ON DUPLICATE KEY UPDATE name = VALUES(name);
-- UPDATE
UPDATE users SET is_active = 0 WHERE id = 5;
UPDATE users SET age = age + 1 WHERE is_active = 1;
-- DELETE
DELETE FROM users WHERE id = 5;
DELETE FROM users WHERE created_at < '2020-01-01';
-- TRUNCATE (fast delete all rows)
TRUNCATE TABLE temp_logs;