Re: Transactional DataBases
| From: | Martin Tsachev | Date: | Tue, 13 Aug 2002 00:19:45 +0000 |
| Subject: | Re: Transactional DataBases | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2099@lists.php.net to get a copy of this message | ||
On Tue August 13 2002 3:09 am, William Lovaton wrote:
> Hi,
Hi Willim,
> I would like to know if there is a way to get advantages from
> Transactional DataBases in PEAR (like Oracle).
Yes, check the autoCommit, commit and rollback methods.
> I'm not sure if PERA DB can do this but I would like to start the
> transaction, executes many queries, then close the transaction. And just
> leaving the transactionality problem to the RDBMS.
>
> It's a shame that MySQL doesn't have transactions support... We'll have
> to wait until 4.1.x ;-)
MySQL supports it, you just need to change your table type to BDB or InnoDB.
--
Martin Tsachev
Web developer
http://martin.f2o.org