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]

identifiers [See naming conventions]

IGNORE algorithm IN operator

index info directive (PRAGMA command) 2nd index list_directive (PRAGMA command) 2nd

indexes 2nd

     benchmarking 2nd 3rd     benefits of 2nd 3rd 4th     creating 2nd 3rd 4th     dropping 2nd

     examples 2nd 3rd 4th 5th 6th     multiple columns 2nd     sort order

     table lists 2nd

     unique indexes 2nd 3rd 4th

     when to create 2nd

     when to use 2nd 3rd INSERT INTO statement 2nd

     sample database 2nd 3rd 4th 5th

INSERT statement 2nd 3rd     VALUES keyword 2nd

installation

     Perl DBI (Database Interface) 2nd 3rd     PySQLite 2nd    SQLite         binary installation for Linux 2nd

         binary installation for Windows 2nd

         installing from source code 2nd

         RPM installation for Linux 2nd

installed_versions() function

INTEGER data type

Integer opcode

INTEGER PRIMARY KEY columns 2nd

integrity_check directive (PRAGMA command)

IntegrityError class

InterfaceError class

internal data manipulation

InternalError class

interrupting     SQL statements     triggers 2nd

INTERSECT statement

IS NOT NULL operator IS NULL operator

isError() function