Lines Matching refs:FROM
124 /* popen and pclose are not C89 functions and so are sometimes omitted from
421 ** from within an SQL statement. This program used to use the
442 ** This routine reads a line of text from FILE in, stores
443 ** the text in memory obtained from malloc() and returns a pointer
447 ** If zLine is not NULL then it is a malloced buffer returned from
482 ** If in==0 then read from standard input and prompt before each line.
486 ** If zPrior is not NULL then it is a buffer from a prior call to this
489 ** The result is stored in space obtained from malloc() and must either
514 ** Shell output mode information from before ".explain on",
551 char nullValue[20]; /* The text to print when a NULL comes back from
1102 ** from malloc(), or a NULL pointer. The string pointed to by zAppend is
1103 ** added to zIn, and the result returned in memory obtained from malloc().
1588 break; /* from for */
1667 zPrepStmt = "DELETE FROM sqlite_sequence;\n";
1733 zSelect = appendText(zSelect, "|| ')' FROM ", 0);
1791 ".clone NEWDB Clone data into NEWDB from the existing database\n"
1805 ".import FILE TABLE Import data from FILE into TABLE\n"
1835 ".restore ?DB? FILE Restore content of DB (default \"main\") from FILE\n"
2136 ** A routine for handling output from sqlite3_trace().
2162 FILE *in; /* Read the CSV text from this input stream */
2188 ** + Input comes from p->in.
2190 ** from sqlite3_malloc64().
2262 ** + Input comes from p->in.
2264 ** from sqlite3_malloc64().
2315 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\"", zTable);
2389 zQuery = sqlite3_mprintf("SELECT * FROM \"%w\" ORDER BY rowid DESC;",
2425 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2452 zQuery = sqlite3_mprintf("SELECT name, sql FROM sqlite_master"
2570 "SELECT count(*) FROM %s WHERE type='table'" },
2572 "SELECT count(*) FROM %s WHERE type='index'" },
2574 "SELECT count(*) FROM %s WHERE type='trigger'" },
2576 "SELECT count(*) FROM %s WHERE type='view'" },
2578 "SELECT total(length(sql)) FROM %s" },
2809 "SELECT name, type, sql FROM sqlite_master "
2813 "SELECT name, type, sql FROM sqlite_master "
2817 "SELECT sql FROM sqlite_master "
2825 "SELECT name, type, sql FROM sqlite_master "
2829 "SELECT sql FROM sqlite_master "
2918 "SELECT sql FROM"
2920 " FROM sqlite_master UNION ALL"
2921 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
2929 "SELECT rowid FROM sqlite_master"
2943 shell_exec(p->db, "SELECT * FROM sqlite_stat1",
2946 shell_exec(p->db, "SELECT * FROM sqlite_stat3",
2949 shell_exec(p->db, "SELECT * FROM sqlite_stat4",
2970 char *zFile; /* Name of file to extra content from */
3045 zSql = sqlite3_mprintf("SELECT * FROM %s", zTable);
3175 "SELECT name FROM sqlite_master "
3178 "SELECT name FROM sqlite_temp_master "
3186 "SELECT name FROM sqlite_master "
3189 "SELECT name FROM sqlite_temp_master "
3582 "SELECT sql FROM "
3584 " FROM sqlite_master UNION ALL"
3585 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3594 "SELECT sql FROM "
3596 " FROM sqlite_master UNION ALL"
3597 " SELECT sql, type, tbl_name, name, rowid FROM sqlite_temp_master) "
3736 "SELECT name FROM sqlite_master"
3746 "SELECT 'temp.' || name FROM sqlite_temp_master"
3753 "SELECT '%q.' || name FROM \"%w\".sqlite_master"
4160 ** Read input from *in and process it. If *in==0 then input
4162 ** is coming from a file or device. A prompt is issued and history
4344 ** Read input from the file given by sqliterc_override. Or if that
4345 ** parameter is NULL, take input from ~/.sqliterc
4372 fprintf(stderr,"-- Loading resources from %s\n",sqliterc);
4537 ** mean that nothing is read from stdin */
4559 ** informational messages (like from process_sqliterc) before
4642 ** files from being created if a user mistypes the database name argument
4743 /* Run commands that follow -cmd first and separately from commands
4793 /* Run commands received from standard input
