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;

Mysql with nolock 查询

标签：ble   abs   rom   mit   idt   esc   read   aci   hid