作品列表

MySQL, MSSQL 使用SELECT 不鎖表

張貼者： 創唯資訊 於 凌晨12:20
MSSQL使用 WITH (NOLOCK)
SELECT * FROM TABLE_NAME WITH(NOLOCK);


MySQL需利用SET來設定
------------------------------------------------------
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM TABLE_NAME ;
COMMIT ;
------------------------------------------------------

------------------------------------------------------
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM TABLE_NAME ;
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ;
------------------------------------------------------