Re: insert data into mysql database

[Rick James]

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.)