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
Defining columns with DEFAULT
4. DEFAULT – NULL values
Adding DEFAULT to existing tables
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', and the genre is 'fantasy'. As for the columns min_players, min_time and cooperation, force a NULL value by providing it in the INSERT statement.

Then look at the inserted row. What happened?