RE: [PEAR] Problem using PEAR::DB
| From: | Lukas Smith | Date: | Fri, 26 Sep 2003 14:46:29 +0000 |
| Subject: | RE: [PEAR] Problem using PEAR::DB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-8060@lists.php.net to get a copy of this message | ||
> From: Dennis Sterzenbach [mailto:dennis@darknoise.homeip.net]
> Sent: Friday, September 26, 2003 4:42 PM
> I've got a problem using PEAR::DB.
> I'm already used to the PEAR database abstraction layer,
> but never before I stepped that much into detail of
> MySQL and PEAR.
>
> For me there's obviously no problem putting three queries
> in one SQL string using phpMyAdmin, neither executing it
> on shell.
> But if I try to execute a 'simpleQuery($sql)' with an SQL
> as follows:
> $sql = "DELETE FROM logins WHERE uid=8;
> DELETE FROM users_lists WHERE uid=8;
> DELETE FROM users WHERE uid=8;"
this is called "batch querying" and it is not supported my mysql
(frontbase and mssql support it though).
Regards,
Lukas