EVOLUTION-MANAGER

Edit File: update_int.result

drop table if exists t1, t2, t3; create table t1 (c1 int, c2 int); show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `c1` int(11) DEFAULT NULL, `c2` int(11) DEFAULT NULL ) ENGINE=Mroonga DEFAULT CHARSET=latin1 insert into t1 values (1, 100); insert into t1 values (2, 101); insert into t1 values (3, 102); select * from t1; c1 c2 1 100 2 101 3 102 update t1 set c2=c2+100 where c1=1; select * from t1; c1 c2 1 200 2 101 3 102 update t1 set c2=c2+100 where c1=2; select * from t1; c1 c2 1 200 2 201 3 102 update t1 set c2=c2+100 where c1=3; select * from t1; c1 c2 1 200 2 201 3 202 flush tables; update t1 set c1=5, c2=50; select * from t1; c1 c2 5 50 5 50 5 50 drop table t1;