Lines Matching refs:FROM

58   set v [catch {execsql {COPY test1 FROM 'data1.txt'}} msg]
65   set v [catch {execsql {COPY sqlite_master FROM 'data2.txt'}} msg]
73   execsql {COPY test1 FROM 'data1.txt'}
74   execsql {SELECT * FROM test1 ORDER BY one}
80   execsql {DELETE FROM test1}
81   execsql {COPY test1 FROM 'data2.txt'}
82   execsql {SELECT * FROM test1 ORDER BY one}
88   execsql {DELETE FROM test1}
89   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS ' | '}
90   execsql {SELECT * FROM test1 ORDER BY one}
93   execsql {DELETE FROM test1}
94   execsql {COPY test1 FROM 'data5.txt' USING DELIMITERS '|'}
95   execsql {SELECT * FROM test1 ORDER BY one}
98   execsql {DELETE FROM test1}
99   execsql {COPY test1 FROM 'data4.txt' USING DELIMITERS '|'}
100   execsql {SELECT * FROM test1 ORDER BY one}
106   execsql {DELETE FROM test1}
111   execsql {SELECT * FROM test1 WHERE one=11}
114   execsql {SELECT * FROM test1 WHERE one=22}
117   execsql {SELECT * FROM test1 WHERE two=22}
120   execsql {SELECT * FROM test1 WHERE three=11}
135   execsql {COPY test2 FROM 'data21.txt'}
149     COPY t1 FROM 'data6.txt';
150     SELECT * FROM t1 ORDER BY a;
159     DELETE FROM t1;
160     COPY t1 FROM 'data6.txt';
161     SELECT * FROM t1 ORDER BY a;
171     DELETE FROM t1;
172     COPY t1 FROM 'data6.txt' USING DELIMITERS ':';
173     SELECT * FROM t1 ORDER BY a;
185     DELETE FROM t1;
186     COPY t1 FROM 'data6.txt';
187     SELECT * FROM t1 WHERE a IS NULL;
192     SELECT * FROM t1 WHERE b IS NULL;
202     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
203     SELECT * FROM t1;
211     COPY t1 FROM 'data6.txt' USING DELIMITERS '|';
212     SELECT * FROM t1;
220     COPY OR IGNORE t1 FROM 'data6.txt' USING DELIMITERS '|';
221     SELECT * FROM t1;
229     COPY OR REPLACE t1 FROM 'data6.txt' USING DELIMITERS '|';
230     SELECT * FROM t1;
236     DELETE FROM t1;
238     COPY t1 FROM 'data5.txt' USING DELIMITERS '|';
243     COPY OR REPLACE t1 FROM 'data5.txt' USING DELIMITERS '|';
248     COPY OR IGNORE t1 FROM 'data5.txt' USING DELIMITERS '|';
256     COPY t2 FROM 'dataX.txt' USING DELIMITERS '|';
257     SELECT * FROM t2;