数据库系统实训——实验十——事务

第一部分：样例库的应用
事件处理：
1)关闭自动提交功能
语句：
update vendors set vend_name=‘New’ where vend_id=1001;
select * from vendors;

SET @@AUTOCOMMIT=0; #关闭自动提交
update vendors set vend_name=‘New’ where vend_id=1001;
select * from vendors;
截图：


2)开始事务/结束事务
语句：
START TRANSACTION; # 事务开始
Delete from orderitems Where order_num = 20009;
Delete from orders Where order_num = 20009;
COMMIT; #提交并关闭事务
截图：

3) 撤销事务
语句：
SELECT * FROM orders; #查询显示所有表记录
START TRANSACTION;
DELETE F