Lines Matching refs:FROM
124 ** sometimes omitted from the <stdio.h> header */
419 ** from within an SQL statement. This program used to use the
440 ** This routine reads a line of text from FILE in, stores
441 ** the text in memory obtained from malloc() and returns a pointer
445 ** If zLine is not NULL then it is a malloced buffer returned from
480 ** If in==0 then read from standard input and prompt before each line.
484 ** If zPrior is not NULL then it is a buffer from a prior call to this
487 ** The result is stored in space obtained from malloc() and must either
512 ** Shell output mode information from before ".explain on",
549 char nullValue[20]; /* The text to print when a NULL comes back from
1100 ** from malloc(), or a NULL pointer. The string pointed to by zAppend is
1101 ** added to zIn, and the result returned in memory obtained from malloc().
1591 break; /* from for */
1670 zPrepStmt = "DELETE FROM sqlite_sequence;\n";
1736 zSelect = appendText(zSelect, "|| ')' FROM ", 0);
1794 ".clone NEWDB Clone data into NEWDB from the existing database\n"
1808 ".import FILE TABLE Import data from FILE into TABLE\n"
1838 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
2141 ** A routine for handling output from sqlite3_trace().
2167 FILE *in; /* Read the CSV text from this input stream */
2193 ** + Input comes from p->in.
2195 ** from sqlite3_malloc64().
2267 ** + Input comes from p->in.
2269 ** from sqlite3_malloc64().
2320 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
2394 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2430 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2457 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2575 "SELECT count(*) FROM %s WHERE type='table'" },
2577 "SELECT count(*) FROM %s WHERE type='index'" },
2579 "SELECT count(*) FROM %s WHERE type='trigger'" },
2581 "SELECT count(*) FROM %s WHERE type='view'" },
2583 "SELECT total(length(sql)) FROM %s" },
2830 "SELECT name, type, sql FROM sqlite_master "
2834 "SELECT name, type, sql FROM sqlite_master "
2838 "SELECT sql FROM sqlite_master "
2846 "SELECT name, type, sql FROM sqlite_master "
2850 "SELECT sql FROM sqlite_master "
2939 "SELECT sql FROM"
2941 " FROM sqlite_master UNION ALL"
2942 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
2950 "SELECT rowid FROM sqlite_master"
2964 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2967 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2970 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
2991 char *zFile; /* Name of file to extra content from */
3066 zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
3196 "SELECT name FROM sqlite_master "
3199 "SELECT name FROM sqlite_temp_master "
3207 "SELECT name FROM sqlite_master "
3210 "SELECT name FROM sqlite_temp_master "
3602 "SELECT sql FROM "
3604 " FROM sqlite_master UNION ALL"
3605 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3614 "SELECT sql FROM "
3616 " FROM sqlite_master UNION ALL"
3617 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3760 "SELECT name FROM sqlite_master"
3770 "SELECT 'temp.' || name FROM sqlite_temp_master"
3777 "SELECT '%q.' || name FROM \"%w\".sqlite_master"
4199 ** Read input from *in and process it. If *in==0 then input
4201 ** is coming from a file or device. A prompt is issued and history
4383 ** Read input from the file given by sqliterc_override. Or if that
4384 ** parameter is NULL, take input from ~/.sqliterc
4411 fprintf(stderr,"-- Loading resources from %s\n",sqliterc);
4576 ** mean that nothing is read from stdin */
4598 ** informational messages (like from process_sqliterc) before
4681 ** files from being created if a user mistypes the database name argument
4782 /* Run commands that follow -cmd first and separately from commands
4832 /* Run commands received from standard input
