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

Chapter 44. Basic SQL > The INSERT Statement

The INSERT Statement

The INSERT statement inserts one or more rows into a table. INSERT always takes the name of the table into which data is to be inserted, as well as the appropriate columns and values. The columns are listed as comma delimited in parentheses after the table name, and the values for each column are listed comma delimited in parentheses after the VALUES keyword.

NOTE

Data cannot be inserted into more than one table in a single operation. The same is true for UPDATE and DELETE operations.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint