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: