select * from TestTransaction;

-- 开启事务
Begin Transaction -- isolation read committed 

-- 带条件的更新
update TestTransaction set name = ‘李四‘ where id = 1;

-- 插入数据
INSERT INTO TestTransaction(NAME,age)  VALUES(‘张三‘,18); 

-- 提交事务
COMMIT Transaction

-- 回滚事务
ROLLBACK Transaction

select * from TestTransaction;

-- 开启事务
START TRANSACTION;

-- 带条件的更新

update TestTransaction set name=‘李四‘ where id = 1;

-- 插入数据
insert into TestTransaction(name,age)  values(‘张三‘,18); 

-- 提交事务
COMMIT 

-- 回滚事务
ROLLBACK