Re: Problem using PEAR::DB
| From: | Martin Marques | Date: | Fri, 26 Sep 2003 19:18:27 +0000 |
| Subject: | Re: Problem using PEAR::DB | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-8075@lists.php.net to get a copy of this message | ||
El Vie 26 Sep 2003 11:46, Lukas Smith escribió:
> > 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).
Not only commertial databases support it. PostgreSQL too!
> Regards,
> Lukas
--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------