MySQL Forums
Forum List  »  Perl

Re: DBD mysqlPP - update table remotely
Posted by: Bill Karwin
Date: November 04, 2006 06:00PM

I don't know any answer to this. I never use DBD::mysqlPP, because as far as I can tell it doesn't work with MySQL 4.1 or later.

But if you're doing this within a Perl script anyway, you could process the local CSV file in any number of ways provided by Perl, and insert the data row by row using a prepared INSERT statement. Remember to turn off autocommit to get better throughput.

Or upload the input file to the MySQL server host, and then you can use LOAD DATA INFILE without the LOCAL behavior.

Regards,
Bill K.

Options: ReplyQuote


Subject
Written By
Posted
November 03, 2006 07:53AM
Re: DBD mysqlPP - update table remotely
November 04, 2006 06:00PM


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.