SQLite Syntax
Syntax is a unique set of rules and guidelines. Following is a list of syntax for SQLite.
Case sensitivity:
- SQLite is not case sensitive. But, there are some commands which are case sensitive.
- For example: GLOB and glob have different meaning in SQLite statements.
Comments:
- Comments are used to add more readability in your SQLite code.
- Comments cannot be nested.
- Comments begin with two consecutive “-” characters.
- Sometimes it also appears with “/*” and extend up to and including the next “*/” character pair.
SQLite Statements
All the SQLite statement is started with any of the keywords like SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc. All the statement will end with a semicolon (;).
SQLite ANALYZE Statement
Syntax:
SQLite AND/OR Clause
Syntax:
SQLite ALTER TABLE Statement
Syntax:
SQLite ALTER TABLE Statement (Rename)
Syntax:
SQLite ATTACH DATABASE Statement
Syntax:
SQLite BEGIN TRANSACTION Statement
Syntax:
SQLite BETWEEN Clause
Syntax:
SQLite CREATE INDEX Statement
Syntax:
SQLite CREATE UNIQUE INDEX Statement
Syntax:
SQLite CREATE TABLE Statement
Syntax:
SQLite CREATE TRIGGER Statement
Syntax:
SQLite CREATE VIEW Statement
Syntax:
SQLite CREATE VIRTUAL TABLE Statement
Syntax:
SQLite COMMIT TRANSACTION Statement
Syntax:
SQLite COUNT Clause
Syntax:
SQLite DELETE Statement
Syntax:
SQLite DETACH DATABASE Statement
Syntax:
SQLite DISTINCT Clause
Syntax:
SQLite DROP INDEX Statement
Syntax:
SQLite DROP TABLE Statement
Syntax:
SQLite DROP VIEW Statement
Syntax:
SQLite DROP TRIGGER Statement
Syntax:
SQLite EXISTS Clause
Syntax:
SQLite EXPLAIN Statement
Syntax:
SQLite GLOB Clause
Syntax:
SQLite GROUP BY Clause
Syntax:
SQLite HAVING Clause
Syntax:
SQLite INSERT INTO Statement
Syntax:
SQLite IN Clause
Syntax:
SQLite Like Clause
Syntax:
SQLite NOT IN Clause
Syntax:
SQLite ORDER BY Clause
Syntax:
SQLite PRAGMA Statement
Syntax:
For example:
SQLite RELEASE SAVEPOINT Statement
Syntax:
SQLite REINDEX Statement
Syntax:
SQLite ROLLBACK Statement
Syntax:
SQLite SAVEPOINT Statement
Syntax:
SQLite SELECT Statement
Syntax:
SQLite UPDATE Statement
Syntax:
SQLite VACUUM Statement
Syntax: