-- [SQL-9-1-a]
DROP TABLE IF EXISTS startdbpg.ms_acc;
CREATE TABLE startdbpg.ms_acc(
acc_no VARCHAR(40) NOT NULL,
acc_nm VARCHAR(100) NULL,
bal_amt DECIMAL(18,3) NULL
);
ALTER TABLE startdbpg.ms_acc ADD CONSTRAINT pk_ms_acc PRIMARY KEY(acc_no);
INSERT INTO startdbpg.ms_acc(acc_no, acc_nm ,bal_amt)
SELECT 'ACC1' ,'1번계좌' ,3000 UNION ALL
SELECT 'ACC2' ,'2번계좌' ,500 UNION ALL
SELECT 'ACC3' ,'3번계좌' ,0;
SQL
복사
-- [SQL-9-1-1-2-a]
SHOW TRANSACTION ISOLATION LEVEL;
SQL
복사