MySQL Forums
Forum List  »  Perl

To append data to an existing database
Posted by: Lois Kim
Date: June 12, 2007 01:33PM

Hi, MySQL/Perl community members!

I need to append a new data file to an existing database regularly.

Using L'OAD DATA INFILE file.txt INTO TABLE table' gives me an error, "Duplicate entry '2' for key '1' " which I can't figure out what it means.

Can anybody help me?

The new data file will contain one or two thousand records. Thank you!

Lois K.



Edited 1 time(s). Last edit at 06/13/2007 04:35PM by Lois Kim.

Options: ReplyQuote


Subject
Written By
Posted
To append data to an existing database
June 12, 2007 01:33PM


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.