Using NoLock with table alias

[nelco]

Hi,
I am not sure on the syntax of using table alias with NoLock condition. The query I tried is as follows:

Select U.Login, EMAIL
From		MetaQuotes_VelocityDemo.mt4_users NoLock AS U LEFT JOIN MetaQuotes_VelocityDemo.mt4_Trades NoLock AS T ON (U.Login = T.Login)

I even tried this:

Select U.Login, EMAIL
From		MetaQuotes_VelocityDemo.mt4_users AS U NOLOCK LEFT JOIN MetaQuotes_VelocityDemo.mt4_Trades AS T NOLOCK ON (U.Login = T.Login)

I keep getting a syntax error. Could someone help in getting the right syntax?

 

[AdaHacker]

That would be because MySQL doesn't support a NoLock keyword. The reason it appears to work without the table alias is because MySQL lets you specify the table alias without the AS keyword. So the query "SELECT * FROM table1 NoLock" would make NoLock the alias for table1, but would not affect locking.

You might achieve a similar result by changing the transaction isolation level, as suggested here.

 

[nelco]

Thanks for your help, AdaHacker