Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Section C.5. Films Table

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,


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint