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;
99 SQL> Statement Executed
100 +---------------------------------------+
107 +---------------------------------------+
108 \e[?1034hSQL> DROP TABLE t1;
109 SQLRowCount returns 0