2 messages in com.mysql.lists.mysqlRe: Some non-transactional changed ta...
FromSent OnAttachments
obed30 Aug 2006 13:39 
Chris30 Aug 2006 16:46 
Subject:Re: Some non-transactional changed tables couldn't be rolled back
From:Chris (dmag@gmail.com)
Date:08/30/2006 04:46:32 PM
List:com.mysql.lists.mysql

obed wrote:

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 |

Transactions only work for table types that support them. MyISAM is not one of those table types.

If you do a 'show create table' what type/engine is it using?