Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Michael Dykman
...@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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
, 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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Ye Yuan
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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
...@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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Paul DuBois
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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Michael Dykman
:     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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
There seems to be some confusion about 'multi-db'.Within a single MySQL instance, assuming that all your tables are a transactional type (InnoDB isn't the only one), you don't have to do anything special to cross database boundaries. XA is required if you plan to spread your transactions out

START TRANSACTION COMMIT ROLLBACK

2009-10-27 Thread Mosaed AlZamil
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