1 INSERTING
1 RECORDS IN TARGET DB
2 +---------------------------------------+
9 +---------------------------------------+
10 \e[?
1034hSQL
> CREATE TABLE t1
(f1 int
);
12 SQL
> INSERT INTO t1 values
(1);
14 SQL
> +---------------------------------------+
21 +---------------------------------------+
22 \e[?
1034hSQL
> SELECT
* FROM t1
;
30 SQL
> CACHING THROUGH SITE1
31 cachetable
-U root
-P manager
-t t1
32 ---------------------------------------------------------
34 ---------------------------------------------------------
37 INSERTING
1 RECORD IN CACHED TABLE t1 AT CSQL
38 Statement Executed
: Rows Affected
= 1
39 AFTER INSERT AT CSQL DATA IN CSQL
40 ---------------------------------------------------------
42 ---------------------------------------------------------
46 AFTER INSERT AT CSQL DATA IN TDB
47 +---------------------------------------+
54 +---------------------------------------+
55 \e[?
1034hSQL
> SELECT
* FROM t1
;
71 INSERTING ANOTHER RECORD IN CACHED TABLE t1 AT CSQL
72 Statement Executed
: Rows Affected
= 1
73 AFTER INSERT AT CSQL DATA IN CSQL
74 ---------------------------------------------------------
76 ---------------------------------------------------------
81 AFTER INSERT AT CSQL DATA IN TDB
82 +---------------------------------------+
89 +---------------------------------------+
90 \e[?
1034hSQL
> SELECT
* FROM t1
;
100 SQL
> Statement Executed
101 +---------------------------------------+
108 +---------------------------------------+
109 \e[?
1034hSQL
> DROP TABLE t1
;
110 SQLRowCount returns
0