Dear Sir,
I could not find table of innoDB in mysql.
mysql> show tables;
+----------------------+
| Tables_in_mysql |
+-----------------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+----------------------+
I set innodb_table_locks=0 in my.cnf , but ROLLBACK is still not effect.
Could you teach me more ?
Thanks and best regards,
----- Original Message -----
From: "Pooly" <[EMAIL PROTECTED]>
To: "MySQL General" <mysql@lists.mysql.com>
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, 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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]