AutoIt3 (Extras SQLite)
Small. Fast. Reliable.
Choose any three.

Welcome.

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.


Sponsors

Ongoing development and maintenance of SQLite is sponsored in part by SQLite Consortium members, including:

Current Status

  • Version 3.7.2 of SQLite is recommended for all new development. Upgrading from all prior SQLite versions is recommended.

Common Links


Table of Content:

          Introduction

                    SQLite Version 3

                    News

          SQLite Syntax Help

                    aggregate functions

                    ALTER Table

                    ANALYSE

                    ATTACH Database

                    BEGIN Transaction

                    Comment

                    COMMIT Transaction

                    core functions

                    CREATE Index

                    CREATE Table

                    CREATE Trigger

                    CREATE View

                    CREATE Virtual Table

                    date and time functions

                    DELETE

                    DETACH Database

                    DROP Index

                    DROP Table

                    DROP Trigger

                    DROP View

                    END Transaction

                    EXPLAIN

                    Expressions

                    INDEXED BY

                    INSERT

                    keywords

                    ON CONFLICT Clause

                    PRAGMA

                    REINDEX

                    REPLACE

                    ROLLBACK Transaction

                    SAVEPOINT, RELEASE

                    SELECT

                    UPDATE

                    VACUUM

                    Atomic Commit

                    Command Line Tool

                    Data Types

                    Distinctive Features

                    Null Handling

                    File Locking

                    Not Supported Features

                    Query Optimizing

                    Shared Cache Mode

                    Syntax diagrams