Copyright 2025

The Valley of Code

A Flavio Copes project

SQL, how to update data
How to update data stored in a SQL database table

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.


Join my AI Workshop !

The Web Development BOOTCAMP cohort starts in February 2026