Skip to content

Instantly share code, notes, and snippets.

@goyuninfo

goyuninfo/MySQL TRANSACTION ISOLATION LEVEL Example

Created February 26, 2021 15:57
Show Gist options
  • Save goyuninfo/cc3b14bda59be81f1995200ab25aef89 to your computer and use it in GitHub Desktop.
Save goyuninfo/cc3b14bda59be81f1995200ab25aef89 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL TRANSACTION ISOLATION LEVEL Example
mysql > SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
Query OK, 0 rows affected
Time: 0.001s
mysql > SET TRANSACTION ISOLATION LEVEL REPEATABLE READ;
Query OK, 0 rows affected
Time: 0.001s
mysql >
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment