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

SQL Constraints

Introduction
CHECK constraints with a simple condition
CHECK constraints with complex conditions
8. Updating rows with complex constraints
Adding CHECK constraints to existing tables
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

In the video_game table, try to update the price for the game 'Disciples II'. Set price to 250.00.

Stuck? Here's a hint!

Type:

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