PHP与MySQL平台下的事务实现探讨

Discussion of transaction realization under PHP and MySQL platform

针对MySQL数据库不同类型存储引擎的数据表,总结出事务实现的方法及步骤.通过分析MyISAM与InnoDB存储引擎的特点,给出两个数据表为保证数据一致性在两种存储引擎环境下的事务实现方式.设计数据库表时应考虑是否会涉及事务应用以及基于该表的主要操作类型,根据情况决定采用MyISAM或InnoDB存储引擎,再根据不同存储引擎采用不同的方法实现事务.

The methods and steps of transaction realization were summed up according to MySQL tables with different types of storage engine.By analyzing the characteristics of the MyISAM and InnoDB storage engine,the transaction realization steps based on two tables ensuring data consistency were given.Transaction application and main type of operation should be considered in database design,using different storage engine and a different approach to transaction realization according to the decision which storage engine to be used.