6.7. SQL Update

6.7.1. Update One

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

6.7.2. Update Many Columns

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

6.7.3. Update Many Rows

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