Update & Delete
Updating records with UPDATE and deleting with DELETE (the importance of WHERE).
Simple enough for a 5-year-old to understand
UPDATE
UPDATE without WHERE modifies ALL rows — be careful!
CREATE TABLE k(id INTEGER, name TEXT);INSERT INTO k VALUES (1, 'Alex');UPDATE k SET name='Alex L.' WHERE id=1;SELECT name FROM k;