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

The Basics of Creating Tables in SQL

Primary keys – the basics
4. Primary keys – adding new values
Single-column primary keys
Multi-column primary keys
NOT NULL
Review

Instruction

Very good. As you can see, the row has been inserted correctly since we did not have a row with ID of 7 before. Nothing more happens here.

Now that the gap is gone, let's try to add one more row.

Exercise

Add a movie with ID of 13 to the movie table. The title is 'Boyhood', and it was produced in 2014.

Stuck? Here's a hint!

Type:

INSERT INTO movie VALUES (13, 'Boyhood', 2014);