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 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=m.ton...@upscene.com > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=yuan4...@gmail.com > >
