Help for this page
# either my $dbh = DBI->connect("dbi:mysql:dbname;mysql_server_prepare=1", ... # or $dbh->{ mysql_server_prepare } = 1;
export MYSQL_SERVER_PREPARE=1
my $query = qq{SELECT col1, col2, col3 FROM mytable LIMIT ? , ?}; my $sth = $dbh->prepare($query); ... $sth->execute($page_no, $lines); # do something with the page. }
$dbh1->{ mysql_server_prepare } = 0; # emulated prepared statement $dbh2->{ mysql_server_prepare } = 1; # real prepared statement ... print "prepared\n", $dbh2->{Profile}->format; $dbh1->{Profile} =0; $dbh2->{Profile} =0;
www.com | www.net | www.org
No recent polls found