悲观锁

select * from riv_test where a=3 for update;X锁

select * from riv_test where a=3 lock in share mode;S锁

 

posted @ 2017-12-09 15:30  tonggc1668  阅读(88)  评论(0)  编辑  收藏  举报