Re: Importing into an AutoIncrement field

At 22:28 -0600 3/21/03, Paul DuBois wrote: At 20:04 -0800 3/21/03, Todd Cary wrote: I would like to avoid the necessity of specifying all of the fields - instead use the following syntax: INSERT INTO teachers VALUES (1,12345,NULL,'Harry','Smith','707-773-4523',2',... However, the first field is a

Re: Importing into an AutoIncrement field

At 20:04 -0800 3/21/03, Todd Cary wrote: I would like to avoid the necessity of specifying all of the fields - instead use the following syntax: INSERT INTO teachers VALUES (1,12345,NULL,'Harry','Smith','707-773-4523',2',... However, the first field is an autoincrementing field. Will MySQL ignor

Importing into an AutoIncrement field

I would like to avoid the necessity of specifying all of the fields - instead use the following syntax: INSERT INTO teachers VALUES (1,12345,NULL,'Harry','Smith','707-773-4523',2',... However, the first field is an autoincrementing field. Will MySQL ignore my value and overwrite it with the "aut