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

Creating Tables in SQL

Introduction
UNIQUE
NOT NULL
CHECK
24. CHECK - updating rows with complex contraints
DEFAULT
Summary

Instruction

Perfect. As you can see, the insertion succeeded because the condition in the CHECK constraint was met. What happens when we try to change it a little bit?

Exercise

Try to update the price in the table video_game where the name of the game is 'Disciples II'. Set the price to 250.00.

Stuck? Here's a hint!

UPDATE video_game 
SET price = 250.00 
WHERE name = 'Disciples II';