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 表锁
标签：--,数据库,oracel,msql,where,id,select From： https://www.cnblogs.com/wanqiang/p/17326499.html