SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED; START TRANSACTION; SELECT @@transaction_isolation; -- Should return 'SERIALIZABLE' -- Your queries here COMMIT;
use this it will work