Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2008

    Unanswered: Placeholder for autoincrement field ?

    suppose i have a table table1 with columns col1, col2, auto, with auto being auto-incrementing

    every time I want to add a row I have to use the statement specifying the columns

    insert into table1 values (col1, col2) values (val1, val2)

    instead if I want to use the statement below without specifying col names -

    insert into table1 values (col1, col2, col3)

    Is there a dummy value. reserved word that I can specify for col3 ?

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    yes, there is

    this dummy word is NULL | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts