MySQL Forums
Forum List  »  InnoDB

MySQL Windowz Transaction
Posted by: Tomasz
Date: August 22, 2005 08:01AM

Hello

I have problem with my MySQL server and transactions. I installed MySQL server 5.0.11 with MySQL administrator & MySql Query Browser on Win XP Prof. I would like to use transactions, so I have read the manual ana I thought I knew how to do it. I set the tables type to InnoDB (i can't use BDB) and change the default mysqld.exe to mysql-max (or mysql-max-nt). I even used : SET AUTOCOMMIT=0.
I'm doing more less this:
1. START TRANACTION (i've tried also BEGIN /WORK/ )
2. UPDATE some table for example :
UPDATE account SET balance=balance-100 WHERE id=2

---- 1 row affected by the last command, no resulset returned
//Shouldn't it wait until COMMIT ??
3. ROLLBACK
---- Query returned no resultset

And ofcourse the balance remained changed (balance-100).

I looks like Mysql doesn't support transactions.

Does anyone have any suggestions about possible cause of tis problem? Maybe some link? Any advise would be apreciated. I don't know what to do.

Please help me :/
Tom

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Windowz Transaction
2565
August 22, 2005 08:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.