Posted by Ivan Marsh on 07/14/06 18:17

On Fri, 14 Jul 2006 08:58:16 -0700, drec wrote:

> I have a table in which its primary key is auto-incremented. Yet, when
> I try to load data using load data infile, this column will not
> auto-increment. I am leaving that column blank in my file to be
> uploaded, yet it fills this value in with a zero for all records.
>
> Should I be using a php script to load this file? Why isnt this updating
> correctly?

Are you loading the blank information from the file into that field?
Simply leave that field out of the import all together and it should
auto-increment.

--
The USA Patriot Act is the most unpatriotic act in American history.
Feingold-Obama '08 - Because the Constitution isn't history,
It's the law.

[Back to original message]