commit / rollback - MySQL

Moga li da izpolzvam commit / rollback v MySQL?

Kak stava?

pisano e dosta po vyprosa

standartnite tablici na mysql (MyISAM) ne poddyrjat transactions, no InnoDB i BDB poddyrjat

ako do4akash wersiq 4.1 pisheshe 4e shte ima poddryjka na tranzakcii



Krasotata e prehodna, znanieto we4no !!!

No nali uzh i sega poddarzhali tranzaktsii za InnoDB tablitsi?

Ne e li taka?

Да, поддържат ги :)

...

Dobre a zashto togava poluchavam tozi otgovor:

BEGIN WORK;
insert into TBL (TEXT_1,TEXT_2) values (\'1\',\'BBB\');
update TBL set TEXT_2='Wer' where TEXT_1='1' ;
ROLLBACK;

MySQL said: Warning: Some non-transactional changed tables couldn't be rolled back

Tablitsata mi e:
create table TBL (
TEXT_1 text,
TEXT_2 text)
TYPE=InnoDB;

MySQL said: Warning: Some non-transactional changed tables couldn't be rolled back

MySQL kaza: Wnimanie: Nqkoi promeneni tablici, nepoddyrjashti tranzakcii, ne mogat da bydat wyrnati w predishnoto systoqniq


t.e. tablicite (weroiatno MyISAM, ako polzwash default-nite) ne mogat da bydat rollback-nati, shtoto ne poddyrjat transakcii