SQL, how to update data

Mar 31, 2020

Learn how to update data in a SQL table with the UPDATE command, and why the WHERE clause matters so you do not accidentally change every row.

~~~

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.

~~~