Tuesday, August 21, 2012

Transaction rollback not working on MySQL

Transactions in MySQL as described in http://dev.mysql.com/doc/refman/5.0/en/commit.html do not work in MyISAM tables. You need to use a transaction safe storage engine such as InnoDB, otherwise you can rollback all you like as it will not have any effect.