Lines Matching refs:t1
27 CREATE TABLE t1(a TEXT PRIMARY KEY, b, c);
36 WHERE type='index' AND tbl_name='t1';
38 } {{(t1 autoindex 1)}}
45 DROP TABLE t1;
46 CREATE TABLE t1(a INTEGER PRIMARY KEY, b, c);
48 WHERE type='index' AND tbl_name='t1';
57 INSERT INTO t1 VALUES(5,'hello','world');
63 SELECT * FROM t1;
68 SELECT rowid, * FROM t1;
77 INSERT INTO t1 VALUES(5,'second','entry');
83 SELECT rowid, * FROM t1;
88 INSERT INTO t1 VALUES(6,'second','entry');
97 SELECT rowid, * FROM t1;
106 INSERT INTO t1(b,c) VALUES('one','two');
107 SELECT b FROM t1 ORDER BY b;
115 UPDATE t1 SET a=4 WHERE b='one';
116 SELECT * FROM t1;
125 SELECT * FROM t1 WHERE a==4;
134 INSERT INTO t1 VALUES('x','y','z');
140 INSERT INTO t1 VALUES('','y','z');
146 INSERT INTO t1 VALUES(3.4,'y','z');
152 INSERT INTO t1 VALUES(-3,'y','z');
157 execsql {SELECT * FROM t1}
165 CREATE INDEX i1 ON t1(b);
166 SELECT * FROM t1 WHERE b=='y'
171 SELECT * FROM t1 WHERE b=='y' AND rowid<0
176 SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
181 SELECT * FROM t1 WHERE b>='y'
186 SELECT * FROM t1 WHERE b>='y' AND rowid<10
192 UPDATE t1 SET a=8 WHERE b=='y';
193 SELECT * FROM t1 WHERE b=='y';
198 SELECT rowid, * FROM t1;
203 SELECT rowid, * FROM t1 WHERE b<'second'
208 SELECT rowid, * FROM t1 WHERE 'second'>b
213 SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
218 SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b AND 0<rowid
223 SELECT rowid, * FROM t1 WHERE b>'a'
228 DELETE FROM t1 WHERE rowid=4;
229 SELECT * FROM t1 WHERE b>'a';
234 UPDATE t1 SET a=-4 WHERE rowid=8;
235 SELECT * FROM t1 WHERE b>'a';
240 SELECT * FROM t1
256 CREATE INDEX i2 ON t1(a);
261 SELECT * FROM t1 WHERE a=5;
266 SELECT * FROM t1 WHERE a>4 AND a<6;
271 SELECT * FROM t1 WHERE b>='hello' AND b<'hello2';
276 CREATE INDEX i3 ON t1(c,a);
281 SELECT * FROM t1 WHERE c=='world';
285 execsql {INSERT INTO t1 VALUES(11,'hello','world')}
287 SELECT * FROM t1 WHERE c=='world';
292 SELECT * FROM t1 WHERE c=='world' AND a>7;
297 SELECT * FROM t1 WHERE 7<a;
305 SELECT * FROM t1 WHERE 11=rowid
310 SELECT * FROM t1 WHERE 11=rowid AND b=='hello'
315 SELECT * FROM t1 WHERE 11=rowid AND b=='hello' AND c IS NOT NULL;
320 SELECT * FROM t1 WHERE rowid==11
325 SELECT * FROM t1 WHERE oid==11 AND b=='hello'
330 SELECT * FROM t1 WHERE a==11 AND b=='hello' AND c IS NOT NULL;
336 SELECT * FROM t1 WHERE 8<rowid;
341 SELECT * FROM t1 WHERE 8<rowid AND 11>=oid;
346 SELECT * FROM t1 WHERE 11<=_rowid_ AND 12>=a;
351 SELECT * FROM t1 WHERE 0>=_rowid_;
356 SELECT * FROM t1 WHERE a<0;
361 SELECT * FROM t1 WHERE a<0 AND a>10;
369 INSERT INTO t1 VALUES(0,'zero','entry');
372 SELECT * FROM t1 WHERE a=0;
377 SELECT rowid, a FROM t1
391 COPY t1 FROM 'data1.txt';
392 SELECT * FROM t1 WHERE a>=20;
397 SELECT * FROM t1 WHERE b=='hello'
402 DELETE FROM t1 WHERE b='b-21';
403 SELECT * FROM t1 WHERE b=='b-21';
408 SELECT * FROM t1 WHERE a>=20
416 INSERT INTO t1(c,b,a) VALUES('row','new',30);
417 SELECT * FROM t1 WHERE rowid>=30;
422 SELECT * FROM t1 WHERE rowid>20;
431 INSERT INTO t2 SELECT * FROM t1;
443 UPDATE t1 SET c='www' WHERE c='world';
444 SELECT rowid, a, c FROM t1 WHERE c=='www';
477 SELECT b FROM t1 WHERE a=2.0+3.0;
482 SELECT b FROM t1 WHERE a=2.0+3.5;