O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using the INSERT Statement

You use the INSERT statement to add data to a table. INSERT is usually made up of three parts:

  • The table into which you want to insert data, specified with the INTO keyword.

  • The column(s) into which you want to insert values. If you specify more than one item, each must be separated by a comma.

  • The values to insert, which are specified with the VALUES keyword.

The Directors table contains the list of movie directors working with or for Orange Whip Studios. Directors can’t be assigned projects (associated with movies) if they aren’t listed in this table, so any new directors must be added immediately.

See Appendix B, “Sample Application Data Files,” for an explanation of each of the data files and their contents.

Now ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required