MySQL Forums
Forum List  »  Newbie

NOLOCK in MySQL VIEW
Posted by: Jing Heng
Date: November 07, 2022 07:38PM

Hi! I am working on a conversion project to convert Microsoft SQL DB to MySQL.

There is a VIEW that was design to select with NOLOCK in MSSQL. As far as I know MySQL only support SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED for the equivalent effect.

I have this idea to have this setting at the beginning of the VIEW declaration and SET back to REPEATABLE READ at the end. However, I am not sure if this is going to work.

May I know if my idea is correct, or is there any other correct way to do this?

Really appreciate any input from you guys. Many thx in advance!

Options: ReplyQuote


Subject
Written By
Posted
NOLOCK in MySQL VIEW
November 07, 2022 07:38PM
November 08, 2022 05:12AM
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.