SQL Spec

[kawasin73]

• SQL syntax in Sqlite
• https://www.sqlite.org/lang_keywords.html
• https://www.sqlite.org/syntaxdiagrams.html

Syntax

• [ ] aggregate functions
• [ ] ALTER TABLE
• [ ] ANALYZE
• [ ] 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
• [ ] expression #15
• [ ] INDEXED BY
• [ ] INSERT #27
• [ ] keywords
• [ ] ON CONFLICT clause
• [ ] PRAGMA
• [ ] REINDEX
• [ ] RELEASE SAVEPOINT
• [ ] REPLACE
• [ ] RETURNING clause
• [ ] ROLLBACK TRANSACTION
• [ ] SAVEPOINT
• [ ] SELECT #34
• [ ] UPDATE
• [ ] UPSERT
• [ ] VACUUM
• [ ] WITH clause

[kawasin73]

Blob literal

https://www.sqlite.org/lang_expr.html#literal_values_constants_

BLOB literals are string literals containing hexadecimal data and preceded by a single "x" or "X" character. Example: X'53514C697465'

[kawasin73]

Statements

• create table
  • https://www.sqlite.org/lang_createtable.html
• select
  • https://www.sqlite.org/lang_select.html