SQL: Update data with UPDATE

The data stored in a table can be updated using the UPDATE command:

UPDATE people SET age=2 WHERE name='Joe';

It’s important to add the WHERE clause, otherwise this instruction:

UPDATE people SET age=2;

would update all the rows in the table.

Lessons this unit:

0: Introduction
1: Using TablePlus
2: Create a Postgres database
3: Create a new table
4: Add data to a table
5: Query data with SELECT
6: Delete data from the database
7: ▶︎ Update data with UPDATE
8: Null constraints
9: Unique and primary keys
10: Updating a table structure
11: Joins
12: DEMO Using Vercel Postgres COMING SOON