Thread: Back Again!
View Single Post
  #2 (permalink)  
Old 02-26-09, 15:26
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
there is no default for an auto_increment

("these aren't the droids you're looking for")



all your INSERT statements should make no mention of the id at all

INSERT INTO people VALUES
( 'Joe', 'Blow') , ( 'Todd' , 'Kamalfeszchuk' )
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote