lock锁相关 ------------- :: // 特殊操作 select * from where > 0 for update; // 加读锁(X锁) select * from where > 0 lock in share mode; // 加S锁 tx_isolation: 事务的隔离级别 1. read-uncommitted, 2. repleatable-read(默认) 3. read-committed select @@tx_isolation; //查询 set @@tx_isolation='read-uncommitted'; //设定值