Lines Matching refs:FROM
3047 ** SELECT x+1, decimal_mul(v,'2') FROM c WHERE x+1<=971
3048 ** ) INSERT INTO pow2(x,v) SELECT x, v FROM c;
3052 ** SELECT x-1, decimal_mul(v,'0.5') FROM c WHERE x-1>=-1075
3053 ** ) INSERT INTO pow2(x,v) SELECT x, v FROM c;
3061 ** FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
3072 ** FROM pow2, c WHERE pow2.x=ieee754_exponent(c.bin);
3301 ** SELECT * FROM generate_series(0,100,5);
3306 ** SELECT * FROM generate_series(0,100);
3310 ** SELECT * FROM generate_series(20) LIMIT 10;
3330 ** SELECT * FROM generate_series(0,100,5);
3331 ** SELECT * FROM generate_series WHERE start=0 AND stop=100 AND step=5;
3333 ** SELECT * FROM generate_series(0,100);
3334 ** SELECT * FROM generate_series WHERE start=0 AND stop=100;
3336 ** SELECT * FROM generate_series(20) LIMIT 10;
3337 ** SELECT * FROM generate_series WHERE start=20 LIMIT 10;
4683 ** SELECT * FROM fsdir($path [, $dir]);
5681 ** FROM completion($prefix,$wholeline)
5891 "SELECT name FROM \"%w\".sqlite_schema",
5915 "SELECT pti.name FROM \"%w\".sqlite_schema AS sm"
6861 ** SELECT name, sz, datetime(mtime,'unixepoch') FROM zipfile($filename);
9986 "SELECT * FROM main.%Q WHERE sample()", pVtab->pTab->zName
10358 zFmt = "SELECT count(*) FROM sqlite_schema WHERE name=%Q"
10661 "SELECT 'CREATE TEMP' || substr(sql, 7) FROM sqlite_schema "
10711 zWrite = sqlite3_mprintf("DELETE FROM %Q", zInt);
10762 "SELECT type, name, sql, 1 FROM sqlite_schema "
10765 "SELECT type, name, sql, 2 FROM sqlite_schema "
10767 " AND tbl_name IN(SELECT name FROM sqlite_schema WHERE type = 'view') "
10940 "SELECT max(i.seqno) FROM "
10991 "SELECT %s FROM %Q x ORDER BY %s", zCols, zTab, zOrder
10995 "SELECT %s FROM temp."UNIQUE_TABLE_NAME" x ORDER BY %s", zCols, zOrder
11065 "CREATE TABLE temp." UNIQUE_TABLE_NAME " AS SELECT * FROM %Q", zTab
11093 "SELECT s.rowid, s.name, l.name FROM "
11098 "SELECT name, coll FROM pragma_index_xinfo(?) WHERE key";
11210 "SELECT sql FROM sqlite_schema WHERE name NOT LIKE 'sqlite_%%'"
12215 "SELECT data FROM sqlite_dbpage(?) WHERE pgno=?", -1,
13308 p, p->dbIn, "SELECT data FROM sqlite_dbpage(%Q) WHERE pgno=?", p->zDb
13465 " SELECT child FROM sqlite_dbptr('getpage()'), pages WHERE pgno=p"
13473 "FROM sqlite_dbdata('getpage()') WHERE pgno IN ("
13474 " SELECT p FROM pages"
13765 " FROM recovery.schema"
13768 " FROM dbschema "
13774 "SELECT name FROM sqlite_schema "
13835 "SELECT rootpage, sql FROM recovery.schema "
13838 "SELECT rootpage, sql FROM recovery.schema "
13991 "SELECT 1 FROM sqlite_schema WHERE name=?"
14101 " SELECT parent FROM recovery.map AS m, p WHERE m.pgno=p.pgno"
14103 "SELECT p.pgno FROM p, recovery.map m WHERE m.pgno=p.pgno "
14243 " SELECT 1 UNION ALL SELECT ii+1 FROM seq WHERE ii<%lld"
14245 "SELECT ii FROM seq" , p->laf.nPg
14249 "FROM sqlite_dbdata('getpage()') d WHERE d.pgno=? "
14285 "SELECT rootpage FROM recovery.schema "
14293 " SELECT child FROM sqlite_dbptr('getpage()'), pages "
14297 "FROM sqlite_dbdata('getpage()') d, pages p WHERE p.page=d.pgno "
14351 recoverExec(p, p->dbOut, "DELETE FROM sqlite_sequence");
14352 recoverSqlCallback(p, "DELETE FROM sqlite_sequence");
14471 " SELECT read_i32(getpage(trunk.pgno), 0) AS x FROM trunk WHERE x>0"
14474 " SELECT pgno, getpage(pgno) FROM trunk"
14477 " SELECT data, min(16384, read_i32(data, 1)-1), pgno FROM trunkdata"
14479 " SELECT data, n-1, read_i32(data, 2+n) FROM freelist WHERE n>=0"
14484 " SELECT rootpage FROM recovery.schema WHERE rootpage>0"
14487 " SELECT r FROM roots"
14489 " SELECT child FROM sqlite_dbptr('getpage()'), used "
14492 "SELECT page FROM used"
14494 "SELECT freepgno FROM freelist WHERE NOT ?"
14541 " SELECT 1 UNION ALL SELECT ii+1 FROM seq WHERE ii<%lld"
14543 "SELECT pgno, child FROM sqlite_dbptr('getpage()') "
14545 "SELECT NULL, ii FROM seq", p->laf.nPg
14548 "SELECT max(field)+1 FROM sqlite_dbdata('getpage') WHERE pgno = ?"
15196 recoverExec(p, p->dbIn, "SELECT 1 FROM sqlite_schema");
16977 " VALUES(coalesce((SELECT (max(tno)+100)/10 FROM selftest),10),\n"
16982 "FROM sqlite_schema ORDER BY 2'',224))',\n"
16984 "FROM sqlite_schema ORDER BY 2',224));\n"
16987 " 'SELECT hex(sha3_query(''SELECT * FROM \"' ||"
16989 " hex(sha3_query(printf('SELECT * FROM \"%w\" NOT INDEXED',name),224))\n"
16990 " FROM (\n"
16991 " SELECT name FROM sqlite_schema\n"
17000 " SELECT rowid*10,op,cmd,ans FROM [_shell$self];\n"
17606 "SELECT value FROM temp.sqlite_parameters"
18506 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)"
18585 if( !dataOnly ) raw_printf(p->out, "DELETE FROM sqlite_sequence;\n");
18656 appendText(&sSelect, " FROM ", 0);
19624 " FROM completion(%Q) ORDER BY 1", text);
19662 " FROM completion(%Q,%Q) ORDER BY 1",
20058 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
20130 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
20167 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_schema"
20196 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_schema"
20346 "SELECT count(*) FROM %s WHERE type='table'" },
20348 "SELECT count(*) FROM %s WHERE type='index'" },
20350 "SELECT count(*) FROM %s WHERE type='trigger'" },
20352 "SELECT count(*) FROM %s WHERE type='view'" },
20354 "SELECT total(length(sql)) FROM %s" },
20365 "SELECT data FROM sqlite_dbpage(?1) WHERE pgno=1",
20676 ** "EXPLAIN QUERY PLAN SELECT 1 FROM child_table WHERE child_key=?"
20707 " 'EXPLAIN QUERY PLAN SELECT 1 FROM ' || quote(s.name) || ' WHERE '"
20727 "FROM sqlite_schema AS s, pragma_foreign_key_list(s.name) AS f "
21217 ? "SELECT name FROM %s WHERE glob($name,name)"
21218 : "SELECT name FROM %s WHERE name=$name";
21285 const char *zSql = "SELECT %s FROM %s WHERE %s";
21337 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;",
21371 "FROM %s WHERE (%s) AND (data IS NULL OR $dirOnly = 0)"
21498 " FROM fsdir(%Q,%Q) AS disk\n"
21507 " FROM fsdir(%Q,%Q) AS disk\n"
21549 "SELECT 1 FROM %s AS mem"
21820 SELECT DISTINCT t.name FROM ColNames t \
21822 SELECT o.name FROM ColNames o WHERE o.cpos<>t.cpos\
21831 <count(name) FROM ColNames\
21845 (SELECT count(*) FROM ColNames d \
21852 SELECT CAST(ceil(log(count(*)+0.5)) AS INT) FROM ColNames \
21859 ELSE 5 FROM (SELECT count(*) AS nc FROM ColNames) \
21870 " SELECT nlz+1 AS nlz FROM Lzn"
21873 " FROM ColNames t, ColNames o"
21875 " iif(t.name IN (SELECT * FROM RepeatedNames),"
21881 " iif(o.name IN (SELECT * FROM RepeatedNames),"
21892 " suff = iif(name IN (SELECT * FROM RepeatedNames),"
21894 " printf('%.*c%0.*d',(SELECT max(nlz) FROM Lzn)+1,'0',1,t.cpos),2)),"
21906 FROM (\
21908 FROM ColNames ORDER BY cpos\
21914 "FROM ColNames WHERE suff<>'' OR chop!=0"
22418 " SELECT 1 FROM sqlite_schema WHERE "
22451 "SELECT name, type, sql FROM sqlite_schema AS o "
22461 "SELECT sql FROM sqlite_schema AS o "
22511 sqlite3_exec(p->db, "SELECT name FROM sqlite_schema LIMIT 1", 0, 0, 0);
22732 "SELECT sql FROM"
22734 " FROM sqlite_schema UNION ALL"
22735 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_schema) "
22743 "SELECT rowid FROM sqlite_schema"
22755 shell_exec(&data, "SELECT * FROM sqlite_stat1", 0);
22757 shell_exec(&data, "SELECT * FROM sqlite_stat4", 0);
22937 zSql = sqlite3_mprintf("SELECT * FROM %s", zFullTabName);
23106 "SELECT rootpage, 0 FROM sqlite_schema"
23109 "SELECT rootpage, 1 FROM sqlite_schema"
23685 "FROM temp.sqlite_parameters;", -1, &pStmt, 0);
23695 "FROM temp.sqlite_parameters;", -1, &pStmt, 0);
23758 "DELETE FROM temp.sqlite_parameters WHERE key=%Q", azArg[2]);
24001 rc = sqlite3_prepare_v2(p->db, "SELECT name FROM pragma_database_list",
24009 appendText(&sSelect, "SELECT sql FROM", 0);
24027 appendText(&sSelect, " AS sname FROM ", 0);
24036 " 'table', name, name, name, 9e+99, 'main' FROM pragma_module_list",
24360 "SELECT tno,op,cmd,ans FROM selftest ORDER BY tno",
24486 zSql = "SELECT lower(name) FROM sqlite_schema"
24491 zSql = "SELECT lower(name) FROM sqlite_schema"
24506 appendText(&sQuery,"SELECT * FROM ", 0);
24510 appendText(&sQuery,"SELECT type,name,tbl_name,sql FROM sqlite_schema"
24513 appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"
24516 appendText(&sQuery,"SELECT tbl,idx,stat FROM sqlite_stat1"
24519 appendText(&sQuery, "SELECT * FROM ", 0);
24535 " FROM [sha3sum$query]",
24541 " FROM [sha3sum$query]",
24680 appendText(&s, "SELECT name FROM ", 0);
24684 appendText(&s, "||'.'||name FROM ", 0);