If all the tables are InnoDB, XA isn't needed. It doesn't matter
whether all tables are in the same database.
On Oct 28, 2009, at 5:48 AM, Martijn Tonies wrote:
Ah, works for InnoDB I see.
Nice.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
Looks to me we should use XA transaction syntax instead. Check this:
http://dev.mysql.com/doc/refman/5.0/en/xa.html
Thanks,
YY
2009/10/28 Martijn Tonies <m.ton...@upscene.com>
Michael,
Does MySQL support multi-db transactions?
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!
Database questions? Check the forum:
http://www.databasedevelopmentforum.com
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
--
Paul DuBois
Sun Microsystems / MySQL Documentation Team
Madison, Wisconsin, USA
www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org