Lines Matching refs:FROM
118 ** sometimes omitted from the <stdio.h> header */
413 ** from within an SQL statement. This program used to use the
434 ** This routine reads a line of text from FILE in, stores
435 ** the text in memory obtained from malloc() and returns a pointer
439 ** If zLine is not NULL then it is a malloced buffer returned from
474 ** If in==0 then read from standard input and prompt before each line.
478 ** If zPrior is not NULL then it is a buffer from a prior call to this
481 ** The result is stored in space obtained from malloc() and must either
506 ** Shell output mode information from before ".explain on",
543 char nullValue[20]; /* The text to print when a NULL comes back from
1094 ** from malloc(), or a NULL pointer. The string pointed to by zAppend is
1095 ** added to zIn, and the result returned in memory obtained from malloc().
1585 from for */
1664 zPrepStmt = "DELETE FROM sqlite_sequence;\n";
1730 zSelect = appendText(zSelect, "|| ')' FROM ", 0);
1788 ".clone NEWDB Clone data into NEWDB from the existing database\n"
1802 ".import FILE TABLE Import data from FILE into TABLE\n"
1832 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
2119 ** A routine for handling output from sqlite3_trace().
2145 FILE *in; /* Read the CSV text from this input stream */
2171 ** + Input comes from p->in.
2173 ** from sqlite3_malloc64().
2245 ** + Input comes from p->in.
2247 ** from sqlite3_malloc64().
2298 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
2372 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2408 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2435 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2553 "SELECT count(*) FROM %s WHERE type='table'" },
2555 "SELECT count(*) FROM %s WHERE type='index'" },
2557 "SELECT count(*) FROM %s WHERE type='trigger'" },
2559 "SELECT count(*) FROM %s WHERE type='view'" },
2561 "SELECT total(length(sql)) FROM %s" },
2808 "SELECT name, type, sql FROM sqlite_master "
2812 "SELECT name, type, sql FROM sqlite_master "
2816 "SELECT sql FROM sqlite_master "
2824 "SELECT name, type, sql FROM sqlite_master "
2828 "SELECT sql FROM sqlite_master "
2917 "SELECT sql FROM"
2919 " FROM sqlite_master UNION ALL"
2920 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
2928 "SELECT rowid FROM sqlite_master"
2942 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2945 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2948 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
2969 char *zFile; /* Name of file to extra content from */
3044 zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
3174 "SELECT name FROM sqlite_master "
3177 "SELECT name FROM sqlite_temp_master "
3185 "SELECT name FROM sqlite_master "
3188 "SELECT name FROM sqlite_temp_master "
3580 "SELECT sql FROM "
3582 " FROM sqlite_master UNION ALL"
3583 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3592 "SELECT sql FROM "
3594 " FROM sqlite_master UNION ALL"
3595 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3738 "SELECT name FROM sqlite_master"
3748 "SELECT 'temp.' || name FROM sqlite_temp_master"
3755 "SELECT '%q.' || name FROM \"%w\".sqlite_master"
4177 ** Read input from *in and process it. If *in==0 then input
4179 from a file or device. A prompt is issued and history
4361 ** Read input from the file given by sqliterc_override. Or if that
4362 ** parameter is NULL, take input from ~/.sqliterc
4389 fprintf(stderr,"-- Loading resources from %s\n",sqliterc);
4554 ** mean that nothing is read from stdin */
4576 ** informational messages (like from process_sqliterc) before
4659 ** files from being created if a user mistypes the database name argument
4760 /* Run commands that follow -cmd first and separately from commands
4810 /* Run commands received from standard input
