MySql的事务使用与示例详解

show engines //查看mysql锁支持的数据引擎

mysql使用事务的关键字
begin //打开一个事务
mit //提交到数据库
rollback //取消操作
savepoint //保存，部分取消，部分提交
alter table person type=INNODB //修改数据引擎

begin
update person set name='efgh' where id =10
select  from person
rollback
select  from person

alter table person type=INNODB
begin
update person set name='efgh' where id =10
select  from person
mit
select  from person
begin
delete from person where id=21
update person set name='efgh' where id =10
mit/rollback

begin;
update score set score=40 where scoreid=1;
savepoint s1;
update score set score=50 where scoreid=2;
select  from score;
rollback to savepoint s1;
select  from score;
mit;