MySQL :: Re: autoincrement id missing when i do load data local into file

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: autoincrement id missing when i do load data local into file

Posted by: Barry Galbraith
Date: December 25, 2010 03:18PM

Did your .csv files include a value for the auto_increment field? If it did, and the value is valid, it'll be used. If not valid, you'll get an error.

Good luck,
Barry.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

autoincrement id missing when i do load data local into file

Wane cooper

December 25, 2010 05:16AM

Re: autoincrement id missing when i do load data local into file

Peter Brawley

December 25, 2010 11:40AM

Re: autoincrement id missing when i do load data local into file

Wane cooper

December 29, 2010 09:23PM

Re: autoincrement id missing when i do load data local into file

Rick James

January 03, 2011 09:52AM

Re: autoincrement id missing when i do load data local into file

Peter Brawley

January 03, 2011 01:24PM

Re: autoincrement id missing when i do load data local into file

Barry Galbraith

December 25, 2010 03:18PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.