SQL Server and MySQL allow dirty reads to be implemented in a way that improves query efficiency

--sql Server allows dirty read query sql
SELECT * from category with (NOLOCK)

--mysql allow dirty read query SQL MYSQL No syntax sugar, requires native SQL
SET SESSION TRANSACTION Isolation level READ uncommitted;
SELECT * from category;
COMMIT;

Note that session refers to allowing the current session to be dirty read if it is not the entire MySQL instance that allows dirty reads

SQL Server and MySQL allow dirty reads to be implemented in a way that improves query efficiency