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.
→ Here's my latest YouTube video
→ I wrote 17 books to help you become a better developer, download them all at $0 cost by joining my newsletter
→ JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025