From: Martijn Tonies
Date: October 28 2009 10:48am
Subject: Re: START TRANSACTION COMMIT ROLLBACK
List-Archive: http://lists.mysql.com/mysql/219167
Message-Id: <004e01ca57bc$3932f730$1401a8c0@martijnws>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_004B_01CA57C4.9AF2A440"

------=_NextPart_000_004B_01CA57C4.9AF2A440
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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





    --=20
    - michael dykman
    - mdykman@stripped

    "May you live every day of your life."
      Jonathan Swift

    --=20
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql

    To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Dm.tonies@stripped



    --=20
    MySQL General Mailing List
    For list archives: http://lists.mysql.com/mysql
    To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Dyuan4ye3@stripped




------=_NextPart_000_004B_01CA57C4.9AF2A440--