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

Re: START TRANSACTION COMMIT ROLLBACK

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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Paul DuBois
PDATE that on success: COMMIT on error: ROLLBACK - michael dykman On Wed, Oct 28, 2009 at 12:07 AM, Mosaed AlZamil > wrote: Hello Everyone, I am a newbie using innodb. How can I implement START TRANSACTION COMMIT ROLLBACK when I need to update two tables

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
, 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 Ye Yuan
ct 28, 2009 at 12:07 AM, Mosaed AlZamil > 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

Re: START TRANSACTION COMMIT ROLLBACK

2009-10-28 Thread Martijn Tonies
, Mosaed AlZamil 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-27 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 app

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