1.需要等待提交后才可以执行
set autocommit=0;
begin;
select * from goods where id="1" for update;
update goods set counts='78' where id=1
update goods set counts='8899' where id=1
知道commit才提交成功
1.需要等待提交后才可以执行
set autocommit=0;
begin;
select * from goods where id="1" for update;
update goods set counts='78' where id=1
update goods set counts='8899' where id=1
知道commit才提交成功