SAVEPOINT init_status;
SELECt * FROM works WHERe company_name = ‘Netease’;
SELECt * FROM manages WHERe employee_name IN (SELECt employee_name FROM works WHERe company_name = ‘Netease’);
UPDATe manages SET salary = salary*1.1 WHERe employee_name IN (SELECT employee_name FROM works WHERe company_name = ‘Netease’);
UPDATe manages SET salary = (salary/1.1)*1.03 WHERe employee_name IN (SELECT employee_name FROM works WHERe company_name = ‘Netease’) AND salary >100000;
SELECt * FROM manages WHERe employee_name IN (SELECt employee_name FROM works WHERe company_name = ‘Netease’);
ROLLBACK TO init_status;
commit;
SAVEPOINT init_status2;
SELECt * FROM works WHERe company_name = ‘Tensent’;
DELETe FROM works WHERe company_name = ‘Tensent’;
SELECt * FROM works WHERe company_name = ‘Tensent’;
ROLLBACK TO init_status2;
commit;
测试结果
