SQLite
SQL API Reference
SQLite SQL dialect for creating tables, inserting rows, querying data and inspecting schema metadata via PRAGMA.
By EZ4Code Team
SQL Statements
Core SQLite DDL, DML and PRAGMA statements.
CREATE TABLE [IF NOT EXISTS] tbl (col type [constraint], ..., [table_constraint])Creates a new table. SQLite uses dynamic typing; common affinities are TEXT, INTEGER, REAL, BLOB, NUMERIC.
Returns: void
INSERT INTO tbl [(cols)] VALUES (vals) | SELECT ... [ON CONFLICT(cols) DO ...]Inserts rows into a table either by literal values or by selecting from another query.
Returns: void
SELECT cols FROM tbl [WHERE condition] [ORDER BY cols] [LIMIT n]Reads rows from a table with optional filtering, ordering and limiting.
Returns: ResultSet
PRAGMA name [= value]Queries or sets SQLite compile-time and runtime options such as foreign_keys, journal_mode, table_info.
Returns: ResultSet | void