Databases
SQL

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

[← back to the Valley]

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.

◀︎ Delete data from the database
▶︎ Null constraints

Lessons in 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

Join my AI Workshop!

The Web Development BOOTCAMP cohort starts in February 2026