8장 트랜잭션.sql

# 날짜 : 2024/07/19	
# 이름 : 최준혁
# 내용 : 8장 트랜잭션 실습하기


#실습 8-1 트랜잭션 Commit
update `bank_account` set `a_balance` = 100000 where `a_no` ='101-11-1001';
start transaction; -- 트랜잭션 시작

select * from `bank_account`;
update `bank_account` set
							`a_balance` = `a_balance` - 10000
					  where `a_no` = '101-11-1001' ;
update `bank_account` set
							`a_balance` = `a_balance` + 10000
					  where `a_no` = '101-11-1003' ;
commit; -- 작업 확정(트랜잭션 종료)
select * from `bank_account`;

#실습 8-2 트랜잭션 Rollback
START TRANSACTION;
UPDATE `bank_account` SET
							`a_balance` = `a_balance` - 10000
					WHERE `a_no` = '101-11-1001';
UPDATE `bank_account` SET
							`a_balance` = `a_balance` + 10000
					WHERE `a_no` = '101-11-1212';

SELECT * FROM `bank_account`;
ROLLBACK;
SELECT * FROM `bank_account`;

#실습 8-3 커밋 OFF
select @@autocommit ;
set autocommit = 0;
UPDATE `bank_account` SET
							`a_balance` = `a_balance` - 10000
					WHERE 	`a_no` = '101-11-1001';
SELECT * FROM `bank_account`;