用户8894759640213

select * from table_name where ... lock in share mode; select * from table_name where ... for update; Innodb行锁是通过给索引项加锁来实现的，只有通过索引条件检索数据，In…