Skip to content

Instantly share code, notes, and snippets.

@honux77

honux77/atomic.sql

Last active August 20, 2019 15:40
Show Gist options
  • Save honux77/00c0a88e1bf6da1ed6b2462eca38adb1 to your computer and use it in GitHub Desktop.
Save honux77/00c0a88e1bf6da1ed6b2462eca38adb1 to your computer and use it in GitHub Desktop.
Download ZIP
mysql atomic increment example
Raw
atomic.sql
USE honuxdb;
SET SESSION transaction_isolation='SERIALIZABLE';
# SELECT @@GLOBAL.transaction_isolation, @@transaction_isolation;
START TRANSACTION;
SELECT SLEEP(3);
UPDATE SUA SET B = B + 1 WHERE A = 'YJ';
SELECT * FROM SUA;
COMMIT;
@honux77
Copy link
Author

honux77 commented Aug 20, 2019

https://www.byteslounge.com/tutorials/spring-transaction-isolation-tutorial 참고

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment