Re: START TRANSACTION COMMIT ROLLBACK

...@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

, 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

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

...@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

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

:     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

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

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: Stored Procs and Commit/Rollback Transactions

Possibly veering off topic, but I have a strong urge to comment on this, and shall! I am a M$ .NET developer (primarily ASP.NET with SQL Server), and have recently embarked on a project at home, and wished to apply the same sort of principles that I use at work - for example, keeping all

Re: Stored Procs and Commit/Rollback Transactions

(most common) and BDB table types. MyISAM doesn't. Hope that helps. Matt - Original Message - From: Laphan Sent: Thursday, March 18, 2004 5:19 PM Subject: Stored Procs and Commit/Rollback Transactions Hi All OK I admit it I'm a complete MSV (MySQL Virgin), so I might be asking

RE: Stored Procs and Commit/Rollback Transactions

and Commit/Rollback Transactions Hi Laphan, (I'm sending this to the general list too, since this isn't Windows specific and more people will see it.) MySQL 5.0, which is an early Alpha, does now support stored procedures. http://www.mysql.com/doc/en/Stored_Procedures.html And MySQL also

BeginTrans - Commit - Rollback on MySQL

Hi All, I am trying to establish a transaction-oriented method of posting changes on the MySQL database. I'm using MyODBC 3.51 and VB6. Using the ADO Controls, I use connection.BeginTrans to start the transaction, followed by a series of ado.updates, and finally a connection.committrans to

commit/rollback?

query (on table_2) returns an error. I believe this could be done by using commit/rollback if I used BDB tables. But I'm using MyISAM. Any hints how could I make this? Thanks, Jochen - Before posting, please check: http

Re: commit/rollback?

root -ppassword db_name file; I would like to undo the first operation on table_1 in case the second query (on table_2) returns an error. I believe this could be done by using commit/rollback if I used BDB tables. But I'm using MyISAM. Any hints how could I make this? Thanks, Jochen

BEGIN, COMMIT, ROLLBACK

Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ? mysql BEGIN; Query OK, 0 rows affected (0.00 sec) mysql UPDATE tabgral set codigo=2 where codigo=1 and nrotab=99; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql ROLLBACK; ERROR 1196:

Re: BEGIN, COMMIT, ROLLBACK

**READ THE MANUAL BEFORE POSTING TO THE LIST** http://www.mysql.com/docs On Tue, 10 Apr 2001, Bruno Roselli wrote: Hi. How to use Begin, Commit and Rollback in my tables type MyISAM ? mysql BEGIN; Query OK, 0 rows affected (0.00 sec) mysql UPDATE tabgral set codigo=2 where codigo=1

Re: BEGIN, COMMIT, ROLLBACK

You are using MyISAM tables which do not support transactions. You need to convert your table to either BDB or INNOBASE type in order to use transactions. All the info is in the manual.. John Barton Unix Systems Administrator Primary Networks, Inc. [EMAIL PROTECTED] On Tue, 10 Apr 2001, Bruno