Multiple inserts/updates through DBD::mysql

[jacob stetina]

Hi!

I'm converting a sybase database to mysql. The problem is that I think that DBD::Sybase allows multiple strings, when DBD::mysql does not.

What I need to do looks something like this:
...
$sth = $dbh->prepare("update kalle set lars = 1; update kalle set leif = 2; update
kalle set harry = 3;");
$sth->execute;
...

I get an error in the perl error-log just after the second insert.

Anyone got an ide of how to do a workaround (and not having to execute each sql statement one by one)?

Thanks!
/jacob