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';

Console

Code editor

Result

TableConsole