1182
CREATE TABLE t1 (a int not null primary key, b int not null, key (b)) engine=innodb;
1183
CREATE TABLE t2 (a int not null primary key, b int not null, key (b)) engine=innodb;
1184
INSERT INTO t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10),(11,11),(12,12);
1185
INSERT INTO t2 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9);
1186
update t1,t2 set t1.a=t1.a+100;
1201
update t1,t2 set t1.a=t1.a+100 where t1.a=101;
1216
update t1,t2 set t1.b=t1.b+10 where t1.b=2;
1231
update t1,t2 set t1.b=t1.b+2,t2.b=t1.b+10 where t1.b between 3 and 5 and t1.a=t2.a+100;
1258
1182
CREATE TABLE t2 ( NEXT_T BIGINT NOT NULL PRIMARY KEY) ENGINE=MyISAM;
1259
1183
CREATE TABLE t1 ( B_ID INTEGER NOT NULL PRIMARY KEY) ENGINE=InnoDB;
1260
1184
SET AUTOCOMMIT=0;
1748
1672
SELECT variable_value - @innodb_rows_inserted_orig FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_rows_inserted';
1749
1673
variable_value - @innodb_rows_inserted_orig
1751
1675
SELECT variable_value - @innodb_rows_updated_orig FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_rows_updated';
1752
1676
variable_value - @innodb_rows_updated_orig
1754
1678
SELECT variable_value - @innodb_row_lock_waits_orig FROM information_schema.global_status WHERE LOWER(variable_name) = 'innodb_row_lock_waits';
1755
1679
variable_value - @innodb_row_lock_waits_orig