1 echo UPDATE and DELETE testing
;
3 Statement Executed
: Rows Affected
= 1
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
10 ---------------------------------------------------------
12 ---------------------------------------------------------
20 echo select * from t1 where f1
= 100;
21 ---------------------------------------------------------
23 ---------------------------------------------------------
26 echo update t1
set f2
= 100;
27 Statement Executed
: Rows Affected
= 6
28 echo select * from t1
;
29 ---------------------------------------------------------
31 ---------------------------------------------------------
39 echo update t1
set f2
= 200 where f1
=50;
40 Statement Executed
: Rows Affected
= 1
41 echo select * from t1
;
42 ---------------------------------------------------------
44 ---------------------------------------------------------
52 echo delete from t1 where f1
= 50;
53 Statement Executed
: Rows Affected
= 1
54 echo select * from t1
;
55 ---------------------------------------------------------
57 ---------------------------------------------------------
65 Statement Executed
: Rows Affected
= 5
66 echo select * from t1
;
67 ---------------------------------------------------------
69 ---------------------------------------------------------