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

Console

Code editor

Result

TableConsole