List:General Discussion« Previous MessageNext Message »
From:Ye Yuan Date:October 28 2009 9:55am
Subject:Re: START TRANSACTION COMMIT ROLLBACK
View as plain text  
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.tonies@stripped>

> 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 <moszamil@stripped>
> 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
> - mdykman@stripped
>
> "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=1
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

Thread
START TRANSACTION COMMIT ROLLBACKMosaed AlZamil28 Oct
  • Re: START TRANSACTION COMMIT ROLLBACKMichael Dykman28 Oct
  • Re: START TRANSACTION COMMIT ROLLBACKMartijn Tonies28 Oct
    • Re: START TRANSACTION COMMIT ROLLBACKYe Yuan28 Oct
  • Re: START TRANSACTION COMMIT ROLLBACKMartijn Tonies28 Oct
    • Re: START TRANSACTION COMMIT ROLLBACKPaul DuBois28 Oct
      • Re: START TRANSACTION COMMIT ROLLBACKMichael Dykman28 Oct
  • Re: START TRANSACTION COMMIT ROLLBACKMartijn Tonies28 Oct