Skip to content

Instantly share code, notes, and snippets.

@tk0miya

tk0miya/gist:5954387

Last active December 19, 2015 12:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tk0miya/5954387 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tk0miya/5954387 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL で INSERT 時にロックされてしまう件に関するメモ。
Raw
gistfile1.txt
// Transaction 1.
BEGIN;
INSERT INTO users values(1, "tk0miya");
// Transaction 2.
BEGIN;
INSERT INTO users values(1, "suzuki");
// Transaction 1. が commit or rollback されるまでブロックされる. (なぜ?)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment