Lines Matching refs:t1
29 CREATE TABLE t1(a TEXT PRIMARY KEY, b, c);
38 WHERE type='index' AND tbl_name='t1';
40 } {{(t1 autoindex 1)}}
47 DROP TABLE t1;
48 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
50 WHERE type='index' AND tbl_name='t1';
59 INSERT INTO t1 VALUES(5,'hello','world');
65 SELECT * FROM t1;
70 SELECT rowid, * FROM t1;
79 INSERT INTO t1 VALUES(5,'second','entry');
85 SELECT rowid, * FROM t1;
90 INSERT INTO t1 VALUES(6,'second','entry');
99 SELECT rowid, * FROM t1;
108 INSERT INTO t1(b,c) VALUES('one','two');
109 SELECT b FROM t1 ORDER BY b;
117 UPDATE t1 SET a=4 WHERE b='one';
118 SELECT * FROM t1;
127 SELECT * FROM t1 WHERE a==4;
136 INSERT INTO t1 VALUES('x','y','z');
142 INSERT INTO t1 VALUES('','y','z');
148 INSERT INTO t1 VALUES(3.4,'y','z');
154 INSERT INTO t1 VALUES(-3,'y','z');
159 execsql {SELECT * FROM t1}
167 CREATE INDEX i1 ON t1(b);
168 SELECT * FROM t1 WHERE b=='y'
173 SELECT * FROM t1 WHERE b=='y' AND rowid<0
178 SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
183 SELECT * FROM t1 WHERE b>='y'
188 SELECT * FROM t1 WHERE b>='y' AND rowid<10
194 UPDATE t1 SET a=8 WHERE b=='y';
195 SELECT * FROM t1 WHERE b=='y';
200 SELECT rowid, * FROM t1;
205 SELECT rowid, * FROM t1 WHERE b<'second'
210 SELECT rowid, * FROM t1 WHERE 'second'>b
215 SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
220 SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b AND 0<rowid
225 SELECT rowid, * FROM t1 WHERE b>'a'
230 DELETE FROM t1 WHERE rowid=4;
231 SELECT * FROM t1 WHERE b>'a';
236 UPDATE t1 SET a=-4 WHERE rowid=8;
237 SELECT * FROM t1 WHERE b>'a';
242 SELECT * FROM t1
258 CREATE INDEX i2 ON t1(a);
263 SELECT * FROM t1 WHERE a=5;
268 SELECT * FROM t1 WHERE a>4 AND a<6;
273 SELECT * FROM t1 WHERE b>='hello' AND b<'hello2';
278 CREATE INDEX i3 ON t1(c,a);
283 SELECT * FROM t1 WHERE c=='world';
287 execsql {INSERT INTO t1 VALUES(11,'hello','world')}
289 SELECT * FROM t1 WHERE c=='world';
294 SELECT * FROM t1 WHERE c=='world' AND a>7;
299 SELECT * FROM t1 WHERE 7<a;
307 SELECT * FROM t1 WHERE 11=rowid
312 SELECT * FROM t1 WHERE 11=rowid AND b=='hello'
317 SELECT * FROM t1 WHERE 11=rowid AND b=='hello' AND c IS NOT NULL;
322 SELECT * FROM t1 WHERE rowid==11
327 SELECT * FROM t1 WHERE oid==11 AND b=='hello'
332 SELECT * FROM t1 WHERE a==11 AND b=='hello' AND c IS NOT NULL;
338 SELECT * FROM t1 WHERE 8<rowid;
343 SELECT * FROM t1 WHERE 8<rowid AND 11>=oid;
348 SELECT * FROM t1 WHERE 11<=_rowid_ AND 12>=a;
353 SELECT * FROM t1 WHERE 0>=_rowid_;
358 SELECT * FROM t1 WHERE a<0;
363 SELECT * FROM t1 WHERE a<0 AND a>10;
371 INSERT INTO t1 VALUES(0,'zero','entry');
374 SELECT * FROM t1 WHERE a=0;
379 SELECT rowid, a FROM t1
393 COPY t1 FROM 'data1.txt';
394 SELECT * FROM t1 WHERE a>=20;
399 SELECT * FROM t1 WHERE b=='hello'
404 DELETE FROM t1 WHERE b='b-21';
405 SELECT * FROM t1 WHERE b=='b-21';
410 SELECT * FROM t1 WHERE a>=20
418 INSERT INTO t1(c,b,a) VALUES('row','new',30);
419 SELECT * FROM t1 WHERE rowid>=30;
424 SELECT * FROM t1 WHERE rowid>20;
433 INSERT INTO t2 SELECT * FROM t1;
445 UPDATE t1 SET c='www' WHERE c='world';
446 SELECT rowid, a, c FROM t1 WHERE c=='www';
479 SELECT b FROM t1 WHERE a=2.0+3.0;
484 SELECT b FROM t1 WHERE a=2.0+3.5;