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 ...

Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.