mysql 区间锁

SESSION A:
mysql> select * from t100 where id >100 for update;
+-----+-------+
| id  | value |
+-----+-------+
| 110 | a     |
| 120 | a     |
+-----+-------+
2 rows in set (0.31 sec)


SESSION B:

mysql> insert into t100 values(111,'aa'); ---HANG