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
<[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,
: 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
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)
> ^