← flaviocopes.com

SQL, how to update data

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.