📋 트랜잭션 실습 준비

✅ 테이블 생성

use sbtest;

CREATE TABLE transaction1 (
    consumerid VARCHAR(20),
    amount INT
);

CREATE TABLE transaction2 (
    consumerid VARCHAR(20),
    amount INT
);

CREATE TABLE transaction3 (
    consumerid VARCHAR(20),
    amount INT
);

insert into transaction1 (consumerid, amount) values ('1', 100);
insert into transaction2 (consumerid, amount) values ('1', 100);
insert into transaction3 (consumerid, amount) values ('1', 100);
commit;

SET SQL_SAFE_UPDATES = 0;  -- 안전 모드를 비활성화

delete from transaction1;  -- 테이블 모든행 삭제
delete from transaction2;
delete from transaction3;

SET SQL_SAFE_UPDATES = 1;  -- 안전 모드를 활성화
commit;

select * from transaction1;
select * from transaction2;
select * from transaction3;

📋 트랜잭션 전파 속성

참고 자료: https://mangkyu.tistory.com/269