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
Hi John,
Please refer the output error below:
# perl Makefile.PL -lcl
Using DBI 1.611 (for perl 5.008003 on PA-RISC1.1-thread-multi) installed
in /opt/perl/lib/site_perl/5.8.3/PA-RISC1.1-thread-multi/auto/DBI/
Unknown option: lcl
Invalid arguments at Makefile.PL line 101.
Thanks.
regards,
YC
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
2 bound variables require 2 bound values
my $sth= $dbh-prepare(INSERT INTO users VALUES (?, ?));
my $random_chars = join 'a','b'; //supply AT LEAST 2 values
my $rows = $sth-execute($i, $random_chars);
Martin Gainty
__
Verzicht und