Lines Matching refs:t5
322 CREATE TABLE t5(x,y);
323 INSERT INTO t5 VALUES(1,2);
324 SELECT * FROM t5;
331 } {t1 t2 t3 t4 t5}
340 CREATE TABLE t5(x PRIMARY KEY, y UNIQUE);
341 SELECT * FROM t5;
346 SELECT * FROM t5 ORDER BY y DESC;
351 INSERT INTO t5 VALUES(1,2);
352 INSERT INTO t5 VALUES(3,4);
353 REPLACE INTO t5 VALUES(1,4);
354 SELECT rowid,* FROM t5;
359 DELETE FROM t5 WHERE x>5;
360 SELECT * FROM t5;
365 DELETE FROM t5 WHERE y<3;
366 SELECT * FROM t5;
371 DELETE FROM t5 WHERE x>0;
372 SELECT * FROM t5;