Re: NOLOCK for multiple tables
Posted by:
Rick James
Date: November 29, 2015 12:01PM
Use
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
instead of NOLOCK.
The lack of a syntax error in SELECT comes from MySQL trying to be consistent with other vendors. The open question is whether NOLOCK is honored or simply ignored.
Subject
Written By
Posted
November 16, 2015 09:21AM
November 16, 2015 12:34PM
November 17, 2015 12:29AM
November 17, 2015 12:01PM
Re: NOLOCK for multiple tables
November 29, 2015 12:01PM
November 29, 2015 12:03PM
November 30, 2015 12:31PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.