看看吧 会加哪些锁？
#创建示例表
mysql> create table t4(id int(11) not null,user_id int(11) null,user_name varchar(10) null,create_time varchar(10) null,address varchar(10) null,primary key(id),key idx_time_name(create_time,user_name));
Query OK, 0 rows affected (0.09 sec)
#插入示例数据
mysql> insert into t4(id,user_id,user_name,create_time) values(1,101,'tom',20161010),(4,104,'joe',20160305),(6,106,'tom',20161231);
Query OK, 3 rows affected (0.05 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql> insert into t4(id,user_id,user_name,create_time) values(10,110,'tom',20160101),(100,200,'jack',20161120);
Query OK, 2 rows affected (0.26 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> insert into t4(id,user_id,user_name,create_time,address) values(8,108,'tom',20160515,'sh');
Query OK, 1 row affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
#确认目前的隔离级别
mysql> select @@tx_isolation;
+-----------------+
| @@tx_isolation |
+-----------------+
| REPEATABLE-READ |
+-----------------+
1 row in set (0.00 sec)
ok，执行以下的sql语句
#sql语句如下
mysql> select * from t4 where create_time>'20160101' and create_time <'20161120' and user_name='tom' and address!='' for update;
+----+---------+-----------+-------------+---------+
| id | user_id | user_name | create_time | address |
+----+---------+-----------+-------------+---------+
| 8 | 108 | tom | 20160515 | sh |
+----+---------+-----------+-------------+---------+
创建时间：2021-12-22 10:56
넶浏览量：0
