8.14. SQL Update

8.14.1. Update One

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

8.14.2. Update Many Columns

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

8.14.3. Update Many Rows

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