MySQL--行锁案例分析

最新推荐文章于 2022-07-28 19:55:19 发布

吴声子夜歌

最新推荐文章于 2022-07-28 19:55:19 发布

阅读量294

点赞数 1

分类专栏： MySQL 文章标签： MySQL 行锁

本文链接：https://blog.csdn.net/cold___play/article/details/103284470

版权

MySQL 专栏收录该内容

47 篇文章 4 订阅

订阅专栏

行锁案例分析

建表及准备数据：

CREATE TABLE `test_innodb_lock`(
a INT(11),
b VARCHAR(16)
)ENGINE INNODB;

INSERT INTO test_innodb_lock values(1, 'b2');
INSERT INTO test_innodb_lock values(3, '3');
INSERT INTO test_innodb_lock values(4, '4000');
INSERT INTO test_innodb_lock values(5, '5000');
INSERT INTO test_innodb_lock values(6, '6000');
INSERT INTO test_innodb_lock values(7, '7000');
INSERT INTO test_innodb_lock values(8, '8000');
INSERT INTO test_innodb_lock values(9, '9000');
INSERT INTO test_innodb_lock values(1, 'b1');

CREATE INDEX test_innodb_a_ind on test_innodb_lock(a);

CREATE INDEX test_innodb_lock_b_ind on test_innodb_lock(b);