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