【开源中国 APP 全新上线】“动弹” 回归、集成大模型对话、畅读技术报告”
例如:
START TRANSACTION;
update a
set name = 1
where id = 1;
sleep(10);
update a
set name = 2
where id = 2;
commit;
START TRANSACTION;
update a
set name = 2
where id = 2;
sleep(10);
update a
set name = 1
where id = 1;
commit;
快速执行这两条SQL为什么不会产生?
update是行级锁