| Thread | Tx(1) | Tx(2) | Comment |
|---|---|---|---|
| Step 1 | BEGIN; |
BEGIN; |
Start of transactions |
| Step 2 | SELECT * FROM users WHERE id = 3 FOR NO KEY UPDATE; |
Fufelschmerz
/ example_select_for_no_key_update.md
Created
October 15, 2025 06:58
Fufelschmerz
/ example_insert_to_child_table.md
Created
October 14, 2025 18:22
| Flow | Tx(1) | Tx(2) | Comment |
|---|---|---|---|
| Step 1 | BEGIN; |
BEGIN; |
Start of transactions |
| Step 2 | SELECT * FROM users WHERE id = 1 FOR UPDATE; |
Fetch and lock the row for update in the users table. Id = 1 |
|
| Step 3 |