mySQL 4.0以上都支持事务处理 但我觉得MySQL还有一点急需完成,子查询,这点在写程序的很不方便
应该说BDB和InnoDB表格类型都支持事务!目前的3.23和4.0.x、4.1.x都有事务支持!
MyIASM表如何进行事务处理: mysql> LOCK TABLES tablename1 READ, tablename2 WRITE; mysql> select sum(value) from tablename where tablename2_id=some_id; mysql> update tablename2 set total_value=sum_from_previous_statement where tablename2_id=some_id; mysql> UNLOCK TABLES; BDB表如何进行事务: mysql> BEGIN WORK; mysql> select sum(value) from tablename where tablename2_id=some_id; mysql> update tablename2 set total_value=sum_from_previous_statement where tablename2_id=some_id; mysql> COMMIT;
但我觉得MySQL还有一点急需完成,子查询,这点在写程序的很不方便
mysql> LOCK TABLES tablename1 READ, tablename2 WRITE;
mysql> select sum(value) from tablename where tablename2_id=some_id;
mysql> update tablename2 set total_value=sum_from_previous_statement
where tablename2_id=some_id;
mysql> UNLOCK TABLES; BDB表如何进行事务:
mysql> BEGIN WORK;
mysql> select sum(value) from tablename where tablename2_id=some_id;
mysql> update tablename2 set total_value=sum_from_previous_statement
where tablename2_id=some_id;
mysql> COMMIT;