Lines Matching refs:FROM
469 "SELECT name FROM sqlite_temp_master WHERE type=%Q",
475 "SELECT name FROM %Q.sqlite_master WHERE type=%Q",
598 ** SELECT sj(a, ', ') FROM t1;
753 "DELETE FROM temp.fkey WHERE from_tbl = %Q AND fkid = %d"
777 "FROM temp.v_fkey WHERE database = 'main';"
784 "FROM temp.fkey "
786 "FROM temp.v_col WHERE tablename=to_tbl AND name==to_col"
806 "FROM temp.fkey "
817 "FROM temp.fkey "
819 "(SELECT 1 FROM temp.v_col WHERE pk AND tablename = temp.fkey.to_tbl)"
827 "(SELECT name FROM temp.v_col WHERE pk AND tablename=temp.fkey.to_tbl)"
841 "FROM temp.v_idxlist AS il, temp.v_idxinfo AS ii "
844 "SELECT tablename, 'pk', name FROM temp.v_col WHERE pk;"
848 "FROM (SELECT * FROM temp.idx2 ORDER BY col) "
853 "FROM (SELECT * FROM temp.fkey ORDER BY to_col) "
857 "triggername FROM temp.v_triggers WHERE database='main' AND "
864 "FROM temp.fkey2 "
866 "FROM temp.idx WHERE tablename=to_tbl AND fkey2.cols==idx.cols"
899 " /key_notnull/ AND NOT EXISTS (SELECT 1 FROM /ref/ WHERE /cond1/)\n"
912 " NOT EXISTS (SELECT 1 FROM /ref/ WHERE /cond1/)\n"
924 " EXISTS (SELECT 1 FROM /tbl/ WHERE /cond2/)\n"
937 " EXISTS (SELECT 1 FROM /tbl/ WHERE /cond2/)\n"
991 "multireplace('DELETE FROM /tbl/ WHERE /where/;' "
999 ") FROM temp.fkey "
1039 "SELECT 'DROP TRIGGER main.' || dq(triggername) || ';' FROM triggers"
1957 zPrepStmt = "DELETE FROM sqlite_sequence;\n";
2020 zSelect = appendText(zSelect, "|| ')' FROM ", 0);
2373 "SELECT name, type, sql FROM sqlite_master "
2377 "SELECT name, type, sql FROM sqlite_master "
2381 "SELECT sql FROM sqlite_master "
2389 "SELECT name, type, sql FROM sqlite_master "
2393 "SELECT sql FROM sqlite_master "
2501 zSql = sqlite3_mprintf("SELECT * FROM '%q'", zTable);
2606 "SELECT name FROM sqlite_master "
2609 "SELECT name FROM sqlite_temp_master "
2617 "SELECT name FROM sqlite_master "
2620 "SELECT name FROM sqlite_temp_master "
2856 "SELECT sql FROM "
2858 " FROM sqlite_master UNION ALL"
2859 " SELECT sql, type, tbl_name, name FROM sqlite_temp_master) "
2867 "SELECT sql FROM "
2869 " FROM sqlite_master UNION ALL"
2870 " SELECT sql, type, tbl_name, name FROM sqlite_temp_master) "
2921 "SELECT name FROM sqlite_master "
2924 "SELECT name FROM sqlite_temp_master "
2932 "SELECT name FROM sqlite_master "
2935 "SELECT name FROM sqlite_temp_master "