2 CREATE TABLE test (id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,descr TEXT);
3 -- [sql2cpp] name=select_all
5 SELECT name,descr FROM test;
7 --INSERT INTO test VALUES;
8 --INSERT INTO test (name,descr) VALUES;
9 SELECT * FROM test WHERE name = ? LIMIT ?;
10 -- [sql2cpp] name=select_distinct_limit
12 FROM test ORDER BY id DESC LIMIT ?;
13 -- [sql2cpp] name=Delete
14 --DELETE FROM test WHERE id = ?;
16 CREATE TABLE loc (id INTEGER PRIMARY KEY AUTOINCREMENT, city TEXT, test_id INTEGER);
17 SELECT test.id FROM test JOIN loc ON test_id = id;
18 SELECT test.id FROM test WHERE id = ? UNION SELECT test.id FROM test WHERE id = ?;
19 SELECT id+test_id AS x,? FROM loc ORDER BY id,?/test_id LIMIT ?,100;