The data stored in a table can be updated using the UPDATE
command:
UPDATE people SET age=2 WHERE name='Joe';
It’s important to add the WHERE
clause, otherwise this instruction:
UPDATE people SET age=2;
would update all the rows in the table.