Lines Matching refs:FROM

56   set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
63   set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
71   execsql {COPY test1 FROM 'data1.txt'}
72   execsql {SELECT * FROM test1 ORDER BY one}
78   execsql {DELETE FROM test1}
79   execsql {COPY test1 FROM 'data2.txt'}
80   execsql {SELECT * FROM test1 ORDER BY one}
86   execsql {DELETE FROM test1}
87   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
88   execsql {SELECT * FROM test1 ORDER BY one}
91   execsql {DELETE FROM test1}
92   execsql {COPY test1 FROM 'data5.txt' USING DELIMITERS '|'}
93   execsql {SELECT * FROM test1 ORDER BY one}
96   execsql {DELETE FROM test1}
97   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS '|'}
98   execsql {SELECT * FROM test1 ORDER BY one}
104   execsql {DELETE FROM test1}
109   execsql {SELECT * FROM test1 WHERE one=11}
112   execsql {SELECT * FROM test1 WHERE one=22}
115   execsql {SELECT * FROM test1 WHERE two=22}
118   execsql {SELECT * FROM test1 WHERE three=11}
133   execsql {COPY test2 FROM 'data21.txt'}
147     COPY t1 FROM 'data6.txt';
148     SELECT * FROM t1 ORDER BY a;
157     DELETE FROM t1;
158     COPY t1 FROM 'data6.txt';
159     SELECT * FROM t1 ORDER BY a;
169     DELETE FROM t1;
170     COPY t1 FROM 'data6.txt' USING DELIMITERS ':';
171     SELECT * FROM t1 ORDER BY a;
183     DELETE FROM t1;
184     COPY t1 FROM 'data6.txt';
185     SELECT * FROM t1 WHERE a IS NULL;
190     SELECT * FROM t1 WHERE b IS NULL;
200     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
201     SELECT * FROM t1;
209     COPY t1 FROM 'data6.txt' USING DELIMITERS '|';
210     SELECT * FROM t1;
218     COPY OR IGNORE t1 FROM 'data6.txt' USING DELIMITERS '|';
219     SELECT * FROM t1;
227     COPY OR REPLACE t1 FROM 'data6.txt' USING DELIMITERS '|';
228     SELECT * FROM t1;
234     DELETE FROM t1;
236     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
241     COPY OR REPLACE t1 FROM 'data5.txt' USING DELIMITERS '|';
246     COPY OR IGNORE t1 FROM 'data5.txt' USING DELIMITERS '|';
254     COPY t2 FROM 'dataX.txt' USING DELIMITERS '|';
255     SELECT * FROM t2;