1 INSERTING
5 RECORDS IN TARGET DB
2 +---------------------------------------+
9 +---------------------------------------+
10 \e[?
1034hSQL
> SELECT
* FROM t1
;
11 +-----------+---------------------+-----------+
13 +-----------+---------------------+-----------+
19 +-----------+---------------------+-----------+
22 SQL
> CACHING THROUGH SITE1
23 cachetable
-U root
-P manager
-t t1
25 Statement Executed
: Rows Affected
= 1
26 Statement Executed
: Rows Affected
= 1
27 Statement Executed
: Rows Affected
= 1
28 Statement Executed
: Rows Affected
= 1
29 Statement Executed
: Rows Affected
= 1
36 INSERTING
5 RECORDS IN CACHED TABLE t1 AT CSQL
37 Statement Executed
: Rows Affected
= 1
38 Statement Executed
: Rows Affected
= 1
39 Statement Executed
: Rows Affected
= 1
40 Statement Executed
: Rows Affected
= 1
41 Statement Executed
: Rows Affected
= 1
42 INSERTING
5 RECORDS AT NON CACHED TABLE t2 AT CSQL
43 Statement Executed
: Rows Affected
= 1
44 Statement Executed
: Rows Affected
= 1
45 Statement Executed
: Rows Affected
= 1
46 Statement Executed
: Rows Affected
= 1
47 Statement Executed
: Rows Affected
= 1
54 UPDATING
5 RECORDS IN CACHED TABLE t1 AT CSQL
55 Statement Executed
: Rows Affected
= 5
56 UPDATING
5 RECORDS AT NON CACHED TABLE t2 AT CSQL
57 Statement Executed
: Rows Affected
= 5
64 DELETING
7 RECORDS IN CACHED TABLE t1 AT CSQL
65 Statement Executed
: Rows Affected
= 7
66 DELETING
7 RECORDS AT NON CACHED TABLE t2 AT CSQL
67 Statement Executed
: Rows Affected
= 7
74 +---------------------------------------+
81 +---------------------------------------+
82 \e[?
1034hSQL
> DROP TABLE t1
;
84 SQL
> Statement Executed