Re: DBD mysqlPP - update table remotely
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.
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.