56,677
社区成员
发帖
与我相关
我的任务
分享
create table test_innodb_lock (a int(11),b varchar(16)) engine=innodb;
create index test_innodb_a_ind on test_innodb_lock(a);
create index test_innodb_lock_b_ind on test_innodb_lock(b);
set autocommit =0;
update test_innodb_lock set b=22
where b=6;
update test_innodb_lock set b=33
where b=5
set autocommit=0;
update test_innodb_lock
set b = 'bbbbb' where a = 1 and b = 2
update test_innodb_lock
set b = 'bbbbb' where a = 1 and b = 1100