drop table if exists `runoob_transaction_test`;
CREATE TABLE runoob_transaction_test( id int(5)) engine=innodb; # 创建数据表
select * from runoob_transaction_test;
begin; # 开始事务
insert into runoob_transaction_test value(5);
insert into runoob_transaction_test value(6);
commit; # 提交事务
begin; # 开始事务
insert into runoob_transaction_test values(7);
rollback; # 回滚
select * from runoob_transaction_test;
begin; # 开始事务
中间所有操作都会被撤回
rollback; # 回滚
begin; # 开始事务
中间所有操作会被提交到数据库
commit; # 提交事务