Posted By

BrentS on 09/09/11


Tagged


Versions (?)

insert


 / Published in: SQL
 

  1. --It is possible to write the INSERT INTO statement in two forms.
  2.  
  3. --The first form doesn't specify the column names where the data will be inserted, only their values:
  4.  
  5. INSERT INTO table_name
  6. VALUES (value1, value2, value3,...)
  7. The second form specifies BOTH the COLUMN names AND the VALUES TO be inserted:
  8.  
  9. --The second form specifies both the column names and the values to be inserted:
  10.  
  11. INSERT INTO table_name (column1, column2, column3,...)
  12. VALUES (value1, value2, value3,...)

Report this snippet  

You need to login to post a comment.