数据库锁

1.msql 

<1> 共享锁

select * from rh_dict where id='02228ee0379743d9af2d5e048d06f0b4' lock in share mode;  --msql 共享锁

<2>排他锁

 

select * from rh_dict where id='02228ee0379743d9af2d5e048d06f0b4' for update; --msql 排他锁

2.oracel 

select * from T_PAYMENT_INFO where id='ee0df4ea90104b95939f43e49dde8046' for update;  --oracel  行锁

 

Lock table T_PAYMENT_INFO in share mode; --oracel  表锁