MySQL Forums
Forum List  »  Newbie

Re: NOLOCK in MySQL VIEW
Posted by: Jing Heng
Date: November 08, 2022 11:40PM

I see. Thanks for the info. Is there any alternative we can do to get the equivalent effect?

The syntax in mssql is something like:

CREATE VIEW ABC as
SELECT c1, c2
from table1 WITH (NOLOCK)
where...

Or, if we set the transaction isolation level before calling the view will work?

Also does the "living connection" concept apply to stored procedure as well?

Really appreciate your advice. Thanks!

Options: ReplyQuote


Subject
Written By
Posted
November 07, 2022 07:38PM
November 08, 2022 05:12AM
Re: NOLOCK in MySQL VIEW
November 08, 2022 11:40PM
November 09, 2022 06:23AM


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.