← 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.



Check out my books

© 2023 Flavio Copes Flavio Copes using Notion to Site Notion to Site. Follow on Twitter

Solopreneur? Wannabe? Adventure awaits