Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostgreSQL INSERT, UPDATE, and DELETE Commands

Introduction
Inserting data
Modifying data
Deleting data
CRUD
16. Exercise 2 – Update

Instruction

Excellent! The menu is getting better and better. Are you ready for another exercise?

Exercise

Doberge Cake (ID 3) in our table is too expensive, so customers don't want to buy it. Let's modify the price to 10.

Stuck? Here's a hint!

Type:

UPDATE dish 
SET
  price = 10 
WHERE id = 3;