commit / rollback

SET autocommit = 0;

SET autocommit = 1;

SELECT @@AUTOCOMMIT;

CREATE TABLE emp_tran1 AS
SELECT *
  FROM emp_test;

ALTER TABLE emp_tran1
  ADD CONSTRAINT PRIMARY KEY (emp_no);

CREATE TABLE emp_tran2 AS
SELECT *
  FROM emp_test;
ALTER TABLE emp_tran2
  ADD CONSTRAINT PRIMARY KEY (emp_no);

DELETE FROM emp_tran1;

-- emp_tran2 삭제
DELETE FROM emp_tran2;

-- 삭제 취소
ROLLBACK;




select *
from emp_tran1;

select *
from emp_tran2;



###########################
START TRANSACTION;

-- savepoint A 설정 
SAVEPOINT A;

-- 삭제1 
DELETE FROM EMP_TRAN1 
WHERE SALARY IS NULL;

-- savepoint B 설정 
SAVEPOINT B;

-- 삭제2
DELETE FROM EMP_TRAN1
WHERE EMP_NAME = '맥스웰'
ORDER BY emp_no
LIMIT 1;

-- savepoint B 이후 작업 취소 
ROLLBACK TO SAVEPOINT B;

COMMIT;

SELECT * 
  FROM EMP_TRAN1;