That is correct. Many db interfaces off programmatic abstractions of
these facilities, but you may certainly just issue the statments.
START TRANSACTION
INSERT that
UPDATE that
on success: COMMIT
on error: ROLLBACK
- michael dykman
On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil <mosza...@gmail.com> wrote:
> Hello Everyone,
> I am a newbie using innodb.
> How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update
> two tables
> that are located in two different databases. Would a single START
> TRANSACTION be sufficient ?
> Any help would be appreciated.
> TIA
> Mos
>
--
- michael dykman
- mdyk...@gmail.com
"May you live every day of your life."
Jonathan Swift
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
