SQL, how to update data

How to update data stored in a SQL database table

Published Mar 31, 2020

The data stored in a table can be updated using the UPDATE command:

UPDATE people SET age=2 WHERE name='Roger'

It’s important to add the WHERE clause, otherwise this instruction:

UPDATE people SET age=2

would update all rows in the table.