Re: Rollback is not take effect on MySQL 5.0.18

2006-03-14 Thread Truong Tan Son
449 | +---+--+ 222 rows in set (0.00 sec) Please check what is wrong and teach me. Thanks you, - Original Message - From: "Pooly" <[EMAIL PROTECTED]> To: "MySQL General" Sent: Tuesday, March 14, 2006 2:53 PM Subject: Re: Rollback is no

Re: Rollback is not take effect on MySQL 5.0.18

2006-03-13 Thread Pooly
<[EMAIL PROTECTED]> > To: "MySQL General" > Sent: Monday, March 13, 2006 5:13 PM > Subject: Re: Rollback is not take effect on MySQL 5.0.18 > > > 2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>: > > Dear Sir, > > > > On RedHat Enterprise 4,

Re: Rollback is not take effect on MySQL 5.0.18

2006-03-13 Thread Truong Tan Son
: Monday, March 13, 2006 5:13 PM Subject: Re: Rollback is not take effect on MySQL 5.0.18 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

Re: Rollback is not take effect on MySQL 5.0.18

2006-03-13 Thread Pooly
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) > ^