9.14. SQL Update

9.14.1. Update One

UPDATE astronauts SET
    agency = 'NASA'
WHERE lastname = 'Watney';

9.14.2. Update Many Columns

UPDATE astronauts SET
    firstname = 'Mark',
    lastname = 'Watney',
    agency = 'NASA'
WHERE id = 1;

9.14.3. Update Many Rows

UPDATE astronauts SET
    mission = 'Ares 3'
WHERE lastname IN ('Watney', 'Lewis', 'Martinez');