good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re: Skip problematic lines while populating databaseby dave_the_m (Monsignor) |
on Aug 17, 2020 at 17:33 UTC ( [id://11120844]=note: print w/replies, xml ) | Need Help?? |
You haven't given any indication of what sort of errors you're getting. Are these genuinely bad lines in the input data, or is it merely that by not using Text:CSV and placeholders, your code isn't correctly handling and quoting data fields and thus converting good data into bad SQL?
Dave.
In Section
Seekers of Perl Wisdom
|
|