当前位置:Gxlcms > 数据库问题 > Mysql with nolock 查询

Mysql with nolock 查询

时间:2021-07-01 10:21:17 帮助过:9人阅读

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   

人气教程排行