SQL DML Commands

INSERT INTO users (name, email) VALUES ('John', '[email protected]'); # single row
INSERT INTO users (name, email) VALUES
    ('John', '[email protected]'),
    ('Jane', '[email protected]'); # multiple rows

INSERT INTO archive_users
SELECT * FROM users WHERE created_at < '2020-01-01'; # insert from query

UPDATE users SET age = 26 WHERE id = 1; # update single column
UPDATE users SET age = 26, city = 'NYC' WHERE id = 1; # multiple columns
UPDATE products SET price = price * 1.1; # update all rows

DELETE FROM users WHERE id = 1; # delete specific row
DELETE FROM users WHERE created_at < '2020-01-01'; # delete with condition
DELETE FROM users; # delete all rows

REPLACE INTO users (id, name, email)
VALUES (1, 'John', '[email protected]'); # insert or replace