Other database operations

Updating an existing row

UPDATE tableName
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.