Just wanted to post this here to see if anyone knows the difference.
In MSSQL, there is a hint which can be used to ask the DB to not lock
the tables during queries and then to read un-commited/dirty data. This
command is like
select count(*) from MyTable nolock
in MySQL, I found that I can do the same thing with the same syntax.
Having read through this post in the forum,
I'm just curious to know if anyone knows that they are one and the same.