List:General Discussion« Previous MessageNext Message »
From:jidntt@yahoo.com.ar Date:September 5 2007 3:49pm
Subject:transaction problem
View as plain text  
Hi list!
I've a problem with transaction
I initiate a transaction with "start transaction". Soon i execute 
following query:
* update t1 set t=12; and by I complete I execute rollback but when I do 
it I obtain the following thing:
"non-transactional Some changed tables couldn't be rolled back" and 
update I execute myself updating the data
Why do it?
I'm use MySQL 4.1.20 and MyISAM tables

Thanks,

Pablo
Thread
transaction problemjidntt@yahoo.com.ar5 Sep
  • Re: transaction problemMartijn Tonies5 Sep
  • Re: transaction problemBaron Schwartz5 Sep