Re^2: How to optimise " csv into mysql " using Text:CSV

The usage of placeholders in the OP's code is secure and normal; maybe a little idiomatic but common. There's no programmatic difference between–

$sth = $dbh->prepare("something something ?, ?");
$sth->execute(@args);
[download]

–and–

$place = "?, ?";
$sth = $dbh->prepare("something something $place");
$sth->execute(@args);
[download]

Comment on Re^2: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql Select or Download Code

Replies are listed 'Best First'.
Re^3: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql by chacham (Prior) on Aug 06, 2015 at 14:38 UTC
But it isn't "something something", its "$fieldList."	[reply]
Re^4: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql by Your Mother (Archbishop) on Aug 06, 2015 at 15:33 UTC
Ah, quite right... seems to be trusted data. But still quite right.	[reply]
Re^5: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql by chacham (Prior) on Aug 06, 2015 at 16:29 UTC
seems to be trusted data Trusted data does make a good case for a quick and dirty solution, certainly if it is an ad hoc, temporary solution. However, it may engender the use of dynamic sql elsewhere. Or worse, stick around for a while and even get copied into other scripts because "it works." Personally, i often find that taking the time (and pain) of doing it correctly teaches me a few things.	[reply]
Re^6: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql by taiko (Sexton) on Sep 04, 2015 at 22:09 UTC
Re^7: How to optimise " csv into mysql " using Text:CSV_XS and DBD::Mysql by chacham (Prior) on Sep 08, 2015 at 12:58 UTC