Other database operations
Updating an existing row
SET field = newValue, field2 = newValue2
[WHERE field3 = value]
Changes can't be made that would break a table constraint. eg. Uniqueness, non-null etc.
Deleting an existing row
DELETE FROM tableName
WHERE field = value
A row can't be deleted that breaks a constraint. Eg, Foreign keys to other tables.