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

How to INSERT, UPDATE, and DELETE Data in SQL

Introduction
Inserting data
Modifying data
8. Modify data
Deleting data
CRUD

Instruction

Great! Now that you know how to add data to the database, it's time to learn how to modify existing data.

If you want to change the name of the user with ID 7, you can use the command:

UPDATE user 
SET name = 'Elizabeth'
WHERE id = 7;

Here, user is the modified table, name is the modified column, and 'Elizabeth' is the new value of the column. The WHERE condition tells the database which rows should be modified, and it can be any condition you'd write in a SELECT clause. (Remember that you can always go to the SQL Basics course for more information).

After you run the query, the name for the user with id 7 will be set to 'Elizabeth'. Piece of cake!

Exercise

The owners of the restaurant complain that the item with ID 2 sells poorly. This might be because Spring Scrolls don't really sound like something particularly edible.

Correct the name by changing it to Spring Rolls.