MySQL - Transaction Isolation Levels

1.MySQL基本SQL文

CREATE TABLE PRODUCTS_1 (
PRODUCT_ID int NOT NULL AUTO_INCREMENT,
PRODUCT_NAME varchar(200) NOT NULL,
PRODUCT_TYPE varchar(45) NOT NULL,
PRICE decimal(10,2) NOT NULL,
QUANTITY int NOT NULL default 0,
PRIMARY KEY (PRODUCT_ID),
UNIQUE KEY PRODUCT_NAME_UNIQUE (PRODUCT_NAME)
) ENGINE=InnoDB;

desc store.products_1

INSERT INTO `STORE`.`PRODUCTS_1`
(`PRODUCT_NAME`,
`PRODUCT_TYPE`,
`PRICE`,
`QUANTITY`)
VALUES
('아이폰','mobile',999,10);

UPDATE PRODUCTS_1 
SET 
    quantity = 200
    // quantity = quantity + 50
WHERE
    product_id = 1;
    // product_id in (1,2);

UPDATE PRODUCTS_1 
SET 
    quantity = 200
    // quantity = quantity + 50
WHERE
    product_id = 1;
    // product_id in (1,2);

DELETE FROM PRODUCTS_1 
WHERE PRODUCT_ID = 3;

2. Transaction Isolation Levels

commitコマンドを発行する前に、Xを反映する必要があります.

コミット後にトランザクションを反映