阅读背景:

惊!史上最全的select加锁分析(Mysql)

来源:互联网 

引言

大家在面试中有没遇到面试官问你下面六句Sql的区分呢

select * from table where id = ?
select * from table where id < ?
select * from table where id = ? lock in share mode
select * from table where id < ? lock in share mode
select * from table where id = ? for update
select * from table where id < ? for updateselect * from tabl



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: