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 ? Thanks you and best regards, -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]