Mysql supports transaction processing

Mysql supports transaction processing. In MYSQL, only INNODB and BDB data tables can support transaction processing. In general, the default engine of MYSQL database is MyISAM, which does not support transactions; if you want MYSQL to support transactions, You can manually modify the statement as follows: 1. Run show engines in phpmyadmin. If InnoDB is set to YES, InnoDB is supported; this means that transaction is supported. 2. When creating a table, you can select the InnoDB Engine for the Storage Engine. For a previously created table, you can use alter table name type = InnoDB; or mysql-> alter table table_name engine = InnoDB; to change the data table engine to support transactions.