Cellwise · SQL track

Changing data

Add, change and remove rows safely.

INSERT adds rows, UPDATE changes them, and DELETE removes them. There’s usually no undo, so these are the commands to treat with respect.

An UPDATE or DELETE with no WHERE changes every row in the table. Run it as a SELECT first, to see what it’ll affect.

What you’ll do

• Add a row
• Change some rows
• Remove some rows