in reply to Re^2: SQL::Statement limit clause with placeholders
in thread SQL::Statement limit clause with placeholders

DBD::mysql allows placeholders in the LIMIT clause. It's not clear whether MySQL itself is as accomodating.

The difference arises because DBD::mysql handles placeholders client-side. There is a push to have the DBD hand off placeholders to the server (now that MySQL supports server-side prepares), but the current CPAN version doesn't have that functionality yet. q.v. New twist for DBD::mysql for more on the topic.

  • In general, if you think something isn't in Perl, try it out, because it usually is. :-)
  • "What is the sound of Perl? Is it not the sound of a wall that people have stopped banging their heads against?"
  • Comment on Re^3: SQL::Statement limit clause with placeholders

In Section Seekers of Perl Wisdom