2 echo UPDATE and DELETE testing
;
4 Statement Executed
: Rows Affected
= 1
5 Statement Executed
: Rows Affected
= 1
6 Statement Executed
: Rows Affected
= 1
7 Statement Executed
: Rows Affected
= 1
8 Statement Executed
: Rows Affected
= 1
9 Statement Executed
: Rows Affected
= 1
10 echo select * from t1
;
11 ---------------------------------------------------------
13 ---------------------------------------------------------
21 echo select * from t1 where f1
= 100;
22 ---------------------------------------------------------
24 ---------------------------------------------------------
27 echo update t1
set f2
= 100;
28 Statement Executed
: Rows Affected
= 6
29 echo select * from t1
;
30 ---------------------------------------------------------
32 ---------------------------------------------------------
40 echo update t1
set f2
= 200 where f1
=50;
41 Statement Executed
: Rows Affected
= 1
42 echo select * from t1
;
43 ---------------------------------------------------------
45 ---------------------------------------------------------
53 echo delete from t1 where f1
= 50;
54 Statement Executed
: Rows Affected
= 1
55 echo select * from t1
;
56 ---------------------------------------------------------
58 ---------------------------------------------------------
66 Statement Executed
: Rows Affected
= 5
67 echo select * from t1
;
68 ---------------------------------------------------------
70 ---------------------------------------------------------