Load Data into MySQL

[drec]

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?

[Ivan Marsh]

Re: Load Data into MySQL

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.