On Jun 6, 8:46 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value)
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE '%something%');
So far my Perl code
On Jun 5, 2:57 pm, ashish.mukher...@gmail.com (Ashish Mukherjee)
wrote:
Hello,
Generally, there is no gain to using bind parameters if you don't know the
columns to be projected in advance in SELECT and your LIKE regex is also
dynamic. It can't prepare a query execution plan and cache it for
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE '%something%');
So far my Perl code
Lethal Possum wrote:
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE
ne pouvons accepter aucune responsabilité
pour le contenu fourni.
To: dbi-users@perl.org
From: lethal.pos...@gmail.com
Subject: Re: Issue with prepared statement
Date: Sat, 5 Jun 2010 11:32:55 -0700
On Jun 5, 6:52 pm, listm...@triad.rr.com (listmail) wrote:
Lethal Possum wrote:
Hello
Hello,
Generally, there is no gain to using bind parameters if you don't know the
columns to be projected in advance in SELECT and your LIKE regex is also
dynamic. It can't prepare a query execution plan and cache it for later use,
since the basic constructs of your query keep changing. I am not
Lethal Possum wrote:
Hello,
I am trying to create a prepared statement for the following query in
MySQL:
INSERT IGNORE INTO foo (group, value) (SELECT 101, value FROM bar
WHERE value LIKE '%something%');
So far my Perl code looks something like this:
my $group = 101;
my $pattern =