although some databases and drivers do support this (notably Sybase and SQL Server).From the documentation for DBD::Sybase:
DBD::Sybase has the ability to handle multi-statement SQL commands in a single batch. For example, you could insert several rows in a single batch like this:____________$sth = $dbh->prepare(" insert foo(one, two, three) values(1, 2, 3) insert foo(one, two, three) values(4, 5, 6) insert foo(one, two, three) values(10, 11, 12) insert foo(one, two, three) values(11, 12, 13) "); $sth->execute;
In reply to Re: Batch DB query -- implementation?
by Aristotle
in thread Batch DB query -- implementation?
by zaimoni
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |