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
DEFAULT
28. DEFAULT - NULL values
Summary

Instruction

Great! As you can see, the database inserted the values itself. But what will happen if we force NULL values instead?

Exercise

Let's try to insert another card_game. The name is 'Three Dragon Ante', genre 'fantasy'. As for the columns min_players, min_time and cooperation, force a NULL value by providing it in the INSERT statement. Take a look at the inserted row. What happened?

Stuck? Here's a hint!

INSERT INTO card_game (name, genre, min_players, min_time, cooperation) 
VALUES ('Three Dragon Ante', 'fantasy', NULL, NULL, NULL);