Are transaction functions only relevant for particular database engines on MySQL, or are transactions supported under all MySQL engines, including MyISAM and InnoDB?
someone says here that transactions only work in some tables types
Mysql – Does TRANSACTION/COMMIT/ROLLBACK only work on certain MySQL engines such as InnoDB
MySQLmysql-5.5transaction
Related Question
- Mysql – Any problem will all InnoDB and one MyISAM table
- Mysql – Unable to change engine to MyISAM in MySQL
- PostgreSQL 9.5 Transactions – Does COMMIT Work Within Anonymous plpgsql Function?
- Mysql – Converting Heap to MyISAM issue on temp table defined as innodb
- Mysql – Rows not updated in transactions without any errors
- Mysql – In InnoDB, how does fuzzy checkpointing’s recovery consistency work
Best Answer
The only storage engine ("table type") that supports transactions with the standard MySQL 5.x distributions is InnoDB. MyISAM and the others do not support transactions.
http://dev.mysql.com/doc/refman/5.5/en/ansi-diff-transactions.html