List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:October 28 2009 10:48am
Subject:Re: START TRANSACTION COMMIT ROLLBACK
View as plain text  
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.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