Use the primary key to access the record. You can update multiple fields for any record by comma separating each `field = value` pair. You can also update multiple records at the same time, depending on the `WHERE` query. Always use the `WHERE` clause!
```SQL
UPDATE <tablename>
SET <field> = <value>, <field_2> = <value_2>
WHERE id = <id>;
```