Lección 5 de 9
UPDATE y DELETE
UPDATE cambia datos existentes. DELETE elimina datos. Usa siempre WHERE con UPDATE y DELETE, o afectarás todas las filas de la tabla.
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;