MySQL Forums
Forum List  »  Perl

Re: insert data into mysql database
Posted by: Rick James
Date: October 23, 2010 09:31AM

That's what programming is all about. YOU have to know Perl; YOU have to understand the specifications (at far more detail that specified here). YOU have to write the code.

OTOH, you could hire someone to do it for you. This forum may not be the right place to find someone.

Also,... Consider whether LOAD DATA will do some of the work for you...
1. LOAD DATA, but load things that need to be validated into VARCHARs
2. Run Perl or SQL scripts to do the validation, and copy the data into INT / FLOAT / whatever makes sense for the columns.

Look through CPAN for other helpers -- there are thousands of libraries (of various quality) readily available. There are probably several that will load the data and populate an array of arrays or an array of hashes. (It turns out that a properly formatted csv file is devilishly tricky to parse with a regexp.)

Options: ReplyQuote

Written By
Re: insert data into mysql database
October 23, 2010 09:31AM

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.