悲观锁

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

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