Lines Matching refs:ft

153     CREATE VIRTUAL TABLE ft USING fts5(x);
154     INSERT INTO ft(rowid, x) VALUES(-45,   'a a');
155     INSERT INTO ft(rowid, x) VALUES(12,    'a b');
156     INSERT INTO ft(rowid, x) VALUES(444,   'a c');
157     INSERT INTO ft(rowid, x) VALUES(12300, 'a d');
158     INSERT INTO ft(rowid, x) VALUES(25400, 'a c');
159     INSERT INTO ft(rowid, x) VALUES(25401, 'a b');
160     INSERT INTO ft(rowid, x) VALUES(50000, 'a a');
165       DELETE FROM ft ORDER BY rowid LIMIT 3;
166       SELECT x FROM ft;
172       DELETE FROM ft WHERE ft MATCH 'a' ORDER BY rowid LIMIT 3;
173       SELECT x FROM ft;
179       DELETE FROM ft WHERE ft MATCH 'b' ORDER BY rowid ASC LIMIT 1 OFFSET 1;
180       SELECT rowid FROM ft;
186       UPDATE ft SET x='hello' ORDER BY rowid LIMIT 2 OFFSET 2;
187       SELECT x FROM ft;
193       UPDATE ft SET x='hello' WHERE ft MATCH 'a' 
195       SELECT x FROM ft;