Re: NOLOCK for multiple tables
> 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.
?! Again, execute ...
select nolock.user from mysql.user nolock;
and you'll see that MySQL is interpreting "nolock" as an alias.
Subject
Written By
Posted
November 16, 2015 09:21AM
November 16, 2015 12:34PM
November 17, 2015 12:29AM
November 17, 2015 12:01PM
November 29, 2015 12:01PM
November 29, 2015 12:03PM
Re: NOLOCK for multiple tables
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.