MySQL for update语句分析
实验环境mysql-5.7.35
1、猜想
1.1、InnoDB存储引擎
建表、数据SQL语句如下:
--建表语句
CREATE TABLE `test_for_update` (
`id` bigint(18) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`description` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idx_name` (`name`)
) ENGINE=InnoDB;
--录入数据
insert into `test_for_update` (`id`, `name`, `description`) values('1','还好','111');
insert into `test_for_update` (`id`, `name`, `description`) values('2','色温','222');
insert into `test_for_update` (`id`, `