Thread
:
Back Again!
View Single Post
#
2
(
permalink
)
02-26-09, 15:26
r937
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
r937
View Public Profile
Visit r937's homepage!
Find all posts by r937