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