- InnoDB引擎,只有通过索引检索数据,才会使用行锁,否则的话使用表锁
session1
先开始
set autocommit = 0;
start TRANSACTION;
begin;
update data set age=15 where id=1;
session2
set autocommit
session1
先开始
set autocommit = 0;
start TRANSACTION;
begin;
update data set age=15 where id=1;
session2
set autocommit