5.7. SQL Update

5.7.1. Update One

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

5.7.2. Update Many Columns

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

5.7.3. Update Many Rows

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