MySQL Forums
Forum List  »  Perl

Re: Multiple inserts/updates through DBD::mysql
Posted by: Lyle Hopkins
Date: January 26, 2008 05:15PM

Looking at the DBI docs $dbh->do() doesn't work like that. You'd be better off preparing once then executing with the different values:-

my $sth = $dbh->prepare("UPDATE kalle set ?=?");
$sth->execute("lars",1);
$sth->execute("lars",2);


Lyle Hopkins

Options: ReplyQuote


Subject
Written By
Posted
Re: Multiple inserts/updates through DBD::mysql
January 26, 2008 05:15PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.