Mysql with nolock 查询

MySql

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

SELECT * FROM TrackingSupplierInfo order by CheckingTime desc limit 10000;

SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;

 

 

SqlService

SELECT top 10000  * FROM TrackingSupplierInfo WITH(NOLOCK)  order by CheckingTime desc;