RE: [PEAR] Problem using PEAR::DB
| From: | patrick dot allaert at belgacom dot be | Date: | Fri, 26 Sep 2003 14:56:13 +0000 |
| Subject: | RE: [PEAR] Problem using PEAR::DB | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-8061@lists.php.net to get a copy of this message | ||
>-----Original Message-----
>From: Lukas Smith [mailto:smith@backendmedia.com]
>Sent: 26 September 2003 16:46
>To: 'Dennis Sterzenbach'; 'ML PEAR General PHP.Net'
>Subject: RE: [PEAR] Problem using PEAR::DB
>
>
>> 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
Hi,
It should be nice having a support for "batch querying" in PEAR::DB...
The DB_common should implement a function splitting the queries...
and the specific DB_* (mysql, oci8, sybase,..) should call this splitting functions
if unable to deal with "batch queries".
What do you think about this suggestion ?
Regards,
Patrick Allaert