1 echo set autocommit off;
3 echo create table t1(f1 int not null,f2 int,f3 int);
4 create table t1(f1 int not null,f2 int,f3 int);
5 echo insert into t1 values(1,2,3);
6 insert into t1 values(1,2,3);
7 echo insert into t1 values(10,20,30);
8 insert into t1 values(10,20,30);
9 echo insert into t1 values(100,200,300);
10 insert into t1 values(100,200,300);
11 echo insert into t1 values(1000,2000,3000);
12 insert into t1 values(1000,2000,3000);
15 echo select * from t1;
17 echo update t1 set f2=0,f3=f1+f2+f3 where f1<=100 and f1 >1;
18 update t1 set f2=0,f3=f1+f2+f3 where f1<=100 and f1 >1;