Primary keys – the basics
Single-column primary keys
Multi-column primary keys
NOT NULL
Instruction
Okay, so we've got a table without the constraint. Now, let's see what happens when we do not provide the values.
Exercise
Try to add a new game to the rpg_game table without providing a name for it. You may try to enter values for other fields like classes_no or complexity instead.
Remember that you must provide a value for a primary key column id.
Stuck? Here's a hint!
For instance, type
INSERT INTO rpg_game (id, complexity) VALUES (10, 12);
