1 echo UPDATE and DELETE testing;
3 create table t1 (f1 int, f2 int, primary key (f1));
4 insert into t1 values (10, 20);
5 insert into t1 values (11, 21);
6 insert into t1 values (12, 22);
7 insert into t1 values (13, 23);
8 insert into t1 values (14, 24);
9 insert into t1 values (50, 50);
10 echo select * from t1;
12 echo select * from t1 where f1 = 100;
13 select * from t1 where f1 = 50;
15 echo update t1 set f2 = 100;
16 update t1 set f2 = 100;
17 echo select * from t1;
20 echo update t1 set f2 = 200 where f1 =50;
21 update t1 set f2 =200 where f1 =50;
22 echo select * from t1;
25 echo delete from t1 where f1 = 50;
26 delete from t1 where f1 = 50;
27 echo select * from t1;
32 echo select * from t1;