Introduction
UNIQUE
3. UNIQUE - Adding new rows
NOT NULL
CHECK
DEFAULT
Summary

Instruction

Alright. As you can see, the values in the column name were indeed unique. After all, no two games should share the same name, right?

Exercise

Let's add another board game to our table board_game. It's called Carcassonne, the genre is medieval, min_players is 2, min_age is 10 and the price is estimated at 32.99. Don't worry about the id column - as you may remember, IDENTITY will take care of numbering.

Stuck? Here's a hint!

Type

INSERT INTO board_game (name, genre, min_players, min_age, price) 
VALUES ('Carcassonne', 'medieval', 2, 10, 32.99);

Console

Code editor

Result

TableConsole