Lines Matching refs:FROM
124 ** sometimes omitted from the <stdio.h> header */
381 ** output from UTF-8 into MBCS.
475 ** This routine reads a line of text from FILE in, stores
476 ** the text in memory obtained from malloc() and returns a pointer
480 ** If zLine is not NULL then it is a malloced buffer returned from
534 ** If in==0 then read from standard input and prompt before each line.
538 ** If zPrior is not NULL then it is a buffer from a prior call to this
541 ** The result is stored in space obtained from malloc() and must either
586 ** from malloc(), or a NULL pointer. The string pointed to by zAppend is
587 ** added to zIn, and the result returned in memory obtained from malloc().
650 "FAIL", "FOR", "FOREIGN", "FROM", "FULL", "GLOB", "GROUP", "HAVING", "IF",
683 ** SHA3 hash implementation copied from ../ext/misc/shathree.c
1335 /* End of SHA3 hashing logic copy/pasted from ../ext/misc/shathree.c
1352 ** Shell output mode information from before ".explain on",
1392 char nullValue[20]; /* The text to print when a NULL comes back from
1501 ** to prevent them from being transformed by end-of-line translators.
2088 ** This is the callback routine from sqlite3_exec() that appends all
2118 " VALUES(coalesce((SELECT (max(tno)+100)/10 FROM selftest),10),\n"
2123 "FROM sqlite_master ORDER BY 2'',224))',\n"
2125 "FROM sqlite_master ORDER BY 2',224));\n"
2128 " 'SELECT hex(sha3_query(''SELECT * FROM \"' ||"
2130 " hex(sha3_query(printf('SELECT * FROM \"%w\" NOT INDEXED',name),224))\n"
2131 " FROM (\n"
2132 " SELECT name FROM sqlite_master\n"
2141 " SELECT rowid*10,op,cmd,ans FROM [_shell$self];\n"
2276 { "read_bytes: ", "Bytes read from storage:" },
2667 break; /* from for */
2910 zSql = sqlite3_mprintf("SELECT 1 FROM pragma_index_list(%Q)"
2982 raw_printf(p->out, "DELETE FROM sqlite_sequence;\n");
3050 appendText(&sSelect, " FROM ", 0);
3123 ".clone NEWDB Clone data into NEWDB from the existing database\n"
3136 ".import FILE TABLE Import data from FILE into TABLE\n"
3173 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
3231 ** Read the content of file zName into memory obtained from sqlite3_malloc64()
3239 ** from the file before the buffer is returned. This byte is not included in
3598 ** A routine for handling output from sqlite3_trace().
3635 FILE *in; /* Read the CSV text from this input stream */
3661 ** + Input comes from p->in.
3663 ** from sqlite3_malloc64().
3735 ** + Input comes from p->in.
3737 ** from sqlite3_malloc64().
3788 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
3862 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
3898 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
3925 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
4043 "SELECT count(*) FROM %s WHERE type='table'" },
4045 "SELECT count(*) FROM %s WHERE type='index'" },
4047 "SELECT count(*) FROM %s WHERE type='trigger'" },
4049 "SELECT count(*) FROM %s WHERE type='view'" },
4051 "SELECT total(length(sql)) FROM %s" },
4132 ** [...] Matches one character from the enclosed list of
4323 ** "EXPLAIN QUERY PLAN SELECT rowid FROM child_table WHERE child_key=?"
4354 " 'EXPLAIN QUERY PLAN SELECT rowid FROM ' || quote(s.name) || ' WHERE '"
4355 " || group_concat(quote(s.name) || '.' || quote(f.[from]) || '=?' "
4356 " || fkey_collate_clause(f.[table], f.[to], s.name, f.[from]),' AND ')"
4361 " s.name || '(' || group_concat(f.[from], ', ') || ')'"
4364 " (SELECT name FROM pragma_table_info(f.[table]) WHERE pk=seq+1)"
4367 " 'CREATE INDEX ' || quote(s.name ||'_'|| group_concat(f.[from], '_'))"
4369 " || group_concat(quote(f.[from]) ||"
4370 " fkey_collate_clause(f.[table], f.[to], s.name, f.[from]), ', ')"
4375 "FROM sqlite_master AS s, pragma_foreign_key_list(s.name) AS f "
4689 sqlite3_exec(p->db, "SELECT name, file FROM pragma_database_list",
4747 "SELECT name, type, sql FROM sqlite_master "
4751 "SELECT name, type, sql FROM sqlite_master "
4755 "SELECT sql FROM sqlite_master "
4761 "SELECT name, type, sql FROM sqlite_master "
4767 "SELECT sql FROM sqlite_master "
4850 "SELECT sql FROM"
4852 " FROM sqlite_master UNION ALL"
4853 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
4861 "SELECT rowid FROM sqlite_master"
4875 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
4878 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
4881 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
4902 char *zFile; /* Name of file to extra content from */
4978 zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
5111 zSql = sqlite3_mprintf("SELECT rootpage FROM sqlite_master"
5584 "SELECT sql FROM "
5586 " FROM sqlite_master UNION ALL"
5587 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
5596 "SELECT sql FROM "
5598 " FROM sqlite_master UNION ALL"
5599 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
5894 "SELECT tno,op,cmd,ans FROM selftest ORDER BY tno",
6022 zSql = "SELECT lower(name) FROM sqlite_master"
6027 zSql = "SELECT lower(name) FROM sqlite_master"
6041 appendText(&sQuery,"SELECT * FROM ", 0);
6045 appendText(&sQuery,"SELECT type,name,tbl_name,sql FROM sqlite_master"
6048 appendText(&sQuery,"SELECT name,seq FROM sqlite_sequence"
6051 appendText(&sQuery,"SELECT tbl,idx,stat FROM sqlite_stat1"
6055 appendText(&sQuery, "SELECT * FROM ", 0);
6071 " FROM [sha3sum$query]",
6077 " FROM [sha3sum$query]",
6175 "SELECT name FROM sqlite_master"
6188 "SELECT name FROM sqlite_master"
6198 "SELECT '%q.' || name FROM \"%w\".sqlite_master"
6205 "SELECT '%q.' || name FROM \"%w\".sqlite_master"
6713 ** Read input from *in and process it. If *in==0 then input
6715 ** is coming from a file or device. A prompt is issued and history
6876 ** Read input from the file given by sqliterc_override. Or if that
6877 ** parameter is NULL, take input from ~/.sqliterc
6904 utf8_printf(stderr,"-- Loading resources from %s\n",sqliterc);
7101 ** mean that nothing is read from stdin */
7123 ** informational messages (like from process_sqliterc) before
7208 ** files from being created if a user mistypes the database name argument
7311 /* Run commands that follow -cmd first and separately from commands
7362 /* Run commands received from standard input
