You update all rows in table by simply providing a column_name = value:

UPDATE person SET planet = 'Earth';