I am a bit confused about Innodb deadlock and the "SELECT…FOR UPDATE” statement.
1. Here is a deadlock example
1) Create actor table
Code:
CREATE TABLE actor(actor_id INT NOT NULL, first_name VARCHAR(10), last_name VARCHAR(10), PRIMARY KEY(actor_id) )ENGINE=INNO
Leave a comment: