No such thing as a small change | |
PerlMonks |
Re^2: DBI Question: bulk insertion with Unique-key constraintby lihao (Monk) |
on Apr 24, 2008 at 20:45 UTC ( [id://682722]=note: print w/replies, xml ) | Need Help?? |
But I need to pre-process some columns, otherwise some data got corrupted, like datetime format. So I guess I need at least to use Perl to go through the CSV file and adjust some columns like datetime format, save them into another file and then load data with MySQL. :)
In Section
Seekers of Perl Wisdom
|
|