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 |