Lesson 5 of 9
UPDATE & DELETE
UPDATE changes existing data. DELETE removes data. Always use WHERE with UPDATE and DELETE, or you will affect every row in the table!
SQL
-- Update a specific row
UPDATE users
SET age = 26, country = 'Denmark'
WHERE id = 1;
-- Delete a specific row
DELETE FROM users WHERE id = 5;
-- DANGER: This deletes ALL rows!
-- DELETE FROM users;