Changing Data (INSERT / UPDATE / DELETE)

Now that you can read data, let us add, edit, and remove it.

Insert (INSERT)

INSERT INTO users (name, age)
VALUES ('Alex', 23);

Update (UPDATE)

UPDATE users
SET age = 24
WHERE name = 'Alex';

Without WHERE, all rows will change. Always use it.

Delete (DELETE)

DELETE FROM users
WHERE name = 'Alex';

Same rule: without WHERE, everything gets deleted.

Now let us connect multiple tables.