Talk:SQL Exercises/Movie theatres

Add the unrated movie "One, Two, Three".

INSERT INTO Movies (Title, Rating) VALUES ('One, Two, Three',NULL)

This command does not work on PostGreSQL.

You will either need to provide Movies.Code (PK value) as 9 or in table definition set the column Movies.Code as SERIAL. This will auto increment the Code column every time any record is added.

This will also mean that you need not provide the code values when entering sample data set for Movies table.