Hi all... i'm developing an aplication and i'm need to use begin,
commit, rollback, but when i try to use rollback i get a warning
| Warning | 1196 | Some non-transactional changed tables couldn't be
rolled back |
this is what i did
mysql> begin;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into
users(id,address,crypt,clear,name,uid,gid,home,domain,maildir,imapok,bool1,bool2)
values ('[EMAIL PROTECTED]','[EMAIL
PROTECTED]',encrypt('xxxxx','ab'),'xxxxx','xxxxx',1136,1136,'/','xxxxx.com','/var/spool/maildir/136/',1,1,1);
Query OK, 1 row affected (0.01 sec)
mysql> rollback;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> show warnings;
+---------+------+---------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+---------------------------------------------------------------+
| Warning | 1196 | Some non-transactional changed tables couldn't be
rolled back |
+---------+------+---------------------------------------------------------------+
1 row in set (0.01 sec)
does anybody know how can i fix this... i appreciate any suggestion
thanks a lot in advanced.
--
http://www.obed.org.mx ---> blog
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
