Okay, have you noticed the new element in the code? You should be familiar with the instruction:
CREATE TABLE movie (
id int PRIMARY KEY,
It will create a table called
movie with the columns specified in the parentheses. There, we provide column names with their types. However, after the part
id int, we put the following piece of information:
In this part of the course, we're going to examine primary keys closely. What are they? A primary key is a set of columns which is used to identify a given row in the table. Sounds too vague? Don't worry, we're going to explain that soon!