good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^2: Comparing DBI recordsby parser (Acolyte) |
on Feb 19, 2013 at 20:15 UTC ( [id://1019658]=note: print w/replies, xml ) | Need Help?? |
Great question. The short answer is that I am not SQL savvy enough to do so. I have used dbf2mysql to perform bulk imports to MySQL and that worked fairly well.
The overarching goal is to update the MySQL database with the DBF files and to log the changes made to the master table. I will read up on equi joins and see if I cannot leverage the MySQL engine to do the heavy lifting. Cheers
In Section
Seekers of Perl Wisdom
|
|