Lines Matching refs:t5
320 CREATE TABLE t5(x,y);
321 INSERT INTO t5 VALUES(1,2);
322 SELECT * FROM t5;
329 } {t1 t2 t3 t4 t5}
338 CREATE TABLE t5(x PRIMARY KEY, y UNIQUE);
339 SELECT * FROM t5;
344 SELECT * FROM t5 ORDER BY y DESC;
349 INSERT INTO t5 VALUES(1,2);
350 INSERT INTO t5 VALUES(3,4);
351 REPLACE INTO t5 VALUES(1,4);
352 SELECT rowid,* FROM t5;
357 DELETE FROM t5 WHERE x>5;
358 SELECT * FROM t5;
363 DELETE FROM t5 WHERE y<3;
364 SELECT * FROM t5;
369 DELETE FROM t5 WHERE x>0;
370 SELECT * FROM t5;