C.5. Films Table

The SQL that you use to insert data into the Films table works on all five database systems. One point to note is that the film description for the film 15th Late Afternoon contains the word Shakespeare''s—the second apostrophe tells the database systems that the first apostrophe isn't the end of the text. The code to populate the Films table is contained in the download file called FilmsTable_Data.txt.

INSERT INTO Films
(
  FilmId,
  FilmName,
  YearReleased,
  PlotSummary,
  AvailableOnDVD,