SQLite

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 ( )