Q


Index


[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]

queries [See also result sets]
     DELETE 2nd 3rd
     executing
         dbcmd eval query command 2nd
         sqlite_escape_string() function 2nd 3rd
         sqlite_exec() function 2nd
         sqlite_query() function 2nd 3rd
         sqlite_unbuffered_query() function
     executing with callback functions 2nd 3rd
         sqlite_exec() function 2nd 3rd 4th
     executing without callback functions 2nd 3rd 4th 5th 6th
    finding information about
         dbcmd changes command 2nd
     INSERT statement 2nd
     joins 2nd 3rd 4th 5th
     nested subqueries 2nd
    optimization
         EXPLAIN statement 2nd 3rd 4th
         indexes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th
         PRAGMA statement 2nd
         transactions 2nd
         VACUUM statement 2nd
    result sets
         accessing random rows 2nd
         displaying in HTML tables 2nd 3rd 4th 5th
         returning in single array 2nd 3rd
     returning information about 2nd 3rd 4th
         last_insert_rowid() method
         rows() method
    SELECT
         aggregate functions 2nd 3rd 4th 5th
         AND operator
         arithmetic operators 2nd 3rd
         BETWEEN operator
         callback functions 2nd 3rd
         column aliases 2nd
         FROM clause 2nd
         GROUP BY clause 2nd 3rd 4th
         HAVING clause 2nd
         IN operator
         IS NOT NULL operator
         IS NULL operator
         joins 2nd 3rd 4th 5th
         LEFT JOIN operator 2nd 3rd
         LIKE operator 2nd
         LIMIT clause 2nd
         NOT LIKE operator
         NULL values 2nd
         OR operator
         ORDER BY clause 2nd 3rd
         string comparisons 2nd 3rd
         string operators 2nd
         syntax 2nd 3rd 4th
         WHERE clause 2nd 3rd 4th 5th 6th
    SELECT statement
         output, assigning to variables
         processing results of 2nd
     UPDATE 2nd 3rd 4th
     variable subqueries
query() function
quote() function 2nd 3rd 4th
quotes ( )



SQLite
SQLite
ISBN: 067232685X
EAN: 2147483647
Year: 2004
Pages: 118
Authors: Chris Newman

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net