mysql--死锁

准备数据库

create database mysqlguide;
use mysqlguide;
drop table StockPrice;
create table StockPrice(stock_id int primary key not null, close float, date date);
insert into StockPrice (stock_id, close, date)value(4, 50.00, '2002-05-01');
insert into StockPrice (stock_id, close, date)values(3, 50.00, '2002-05-02');
alter table StockPrice add high float;
update StockPrice set high=20.00 where stock_id=4 and date='2002-05-01';
update StockPrice set high=20.00 where stock_id=3 and date='2002-05-02';

第一个cmd窗口中执行：

start transaction;
update StockPrice set close = 45.50 where stock_id = 4 and date = '2002-05-01';

第二个cmd窗口中执行：

start transaction;
update StockPrice set high = 20.12 where stock_id = 3 and date = '2002-05-02';

第一个cmd窗口中执行：
update StockPrice set close = 19.80 where stock_id = 3 and date = '2002-05-02';
commit;
第二个cmd窗口中执行两次：
update StockPrice set high = 47.20 where stock_id = 4 and date = '2002-05-01';
效果图：
错误代码：1213死锁

错误代码：1205等待超时

ps:
1.事务原文：

start transaction;
update StockPrice set close = 45.50 where stock_id = 4 and date = '2002-05-01';
update StockPrice set close = 19.80 where stock_id = 3 and date = '2002-05-02';
commit;

start transaction;
update StockPrice set high = 20.12 where stock_id = 3 and date = '2002-05-02';
update StockPrice set high = 47.20 where stock_id = 4 and date = '2002-05-01';
commit;