SQL, how to update data

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.

Download my free books, and check out my upcoming Full-Stack JavaScript Bootcamp! A 4-months online training program. Signups now open, until June 1!