2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>: > Dear Sir, > > On RedHat Enterprise 4, and MySQL 5.0.18, I did : > > mysql> set autocommit=0; > > mysql> savepoint abc; > > mysql> insert ....something.... > > mysql> rollback to save point abc; > > Query OK, 0 rows affected, 1 warning (0.00 sec) > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > RollBack is NOT take effect. But on WindowsXP, it is GOOD. > > > What is wrong ?
Did you check if the table are innoDB ? -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]