SQL SQLite Specific

SQLite-specific features — AUTOINCREMENT, ATTACH, VACUUM, PRAGMA, ROWID. This category documents 30 SQL sqlite specific entries, and each page gives you the full syntax, the parameter list, the return value, and a runnable example tested against MySQL, PostgreSQL, SQL Server, and SQLite. The entries are: AUTOINCREMENT (SQLite), ROWID / _ROWID_, ATTACH DATABASE, PRAGMA, VACUUM (SQLite), EXPLAIN QUERY PLAN (SQLite), JSON Functions (SQLite), CREATE VIRTUAL TABLE (FTS5), LIMIT/OFFSET with ORDER BY (SQLite), .dump / .import (CLI), WAL Mode (Write-Ahead Logging), IMMEDIATE / EXCLUSIVE Transaction, RECURSIVE TRIGGER (SQLite), SAVEPOINT (SQLite), TRANSIENT INDEX (SQLite), IN / EXISTS Optimization (SQLite), UPSERT (SQLite ON CONFLICT), SQLite Subquery Performance, SQLite WITHOUT ROWID Tables, SQLite ORDER BY Optimization, SQLite Index on JSON Expression, SQLite Full-Text Search (FTS5), SQLite WAL Journal Mode, SQLite JSON Functions, SQLite CREATE TABLE AS SELECT, SQLite CREATE TRIGGER, SQLite DATETIME Functions, SQLite Database Size, SQLite PRAGMA foreign_keys, SQLite AUTOINCREMENT vs INTEGER PRIMARY KEY. Not sure where to start? AUTOINCREMENT (SQLite) and ROWID / _ROWID_ are the most commonly used entries in this category. You can also search across every category from the search page, browse the complete A–Z index, or try any of these statements live in the SQL playground.