By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Load Data into MySQL

P: n/a
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?

Jul 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Jul 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.