Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Primary keys - the basics
4. Primary keys - adding new values
Single-column primary keys
Multicolumn primary keys
Auto-increment columns and sequences


Very good. As you can see, the row has been inserted correctly because we hadn't had a row with id 7 before. Nothing much happening here.

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


Add a movie with id 13 to the table movie. The title is Boyhood and it was produced in 2014.

Stuck? Here's a hint!


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