When I try to use ROLLBACK in MySQL I have such a message:
--->>>BEGIN WORK;
insert into TBL (TEXT_1,TEXT_2) values (\'AAA\',\'BBB\');
update TBL set TEXT_1=\'Rer\',TEXT_2=\'Wer\' where ID=\'1\' ;
ROLLBACK;
MySQL said: Warning: Some non-transactional changed tables couldn't be rolled back<<<---
But WHY? I use MySQL 3.23.43 and my table is BDB (the same message I have with table InnoDB) So what shall I do? Please advise.
--->>>BEGIN WORK;
insert into TBL (TEXT_1,TEXT_2) values (\'AAA\',\'BBB\');
update TBL set TEXT_1=\'Rer\',TEXT_2=\'Wer\' where ID=\'1\' ;
ROLLBACK;
MySQL said: Warning: Some non-transactional changed tables couldn't be rolled back<<<---
But WHY? I use MySQL 3.23.43 and my table is BDB (the same message I have with table InnoDB) So what shall I do? Please advise.