HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
SQLite is to follow a unique set of rules and guidelines called syntax. This tutorial lists all the basic syntax of SQLite, SQLite provides you with a quick start.
There is an important point to note, SQLite iscase-insensitive, but some commands are case-sensitive, such as GLOBandglobhas different meanings in SQLite statement.
SQLite comments are additional comments, SQLite can add comments in the code to increase readability, they can occur in any empty space in the middle of expressions and include other SQL statements, but they can not be nested.
SQL comment to two consecutive "-" character (ASCII 0x2d) start and extend to the next newline (ASCII 0x0a), or until the end of input, whichever comes first.
You can also use the C-style comment with "/ *" to start, and extended to the next "* /" character of or until the end of input, whichever comes first. SQLite comments can span multiple lines.
sqlite> .help - This is a single line comment
All SQLite statement can start with any keywords, such as SELECT, INSERT, UPDATE, DELETE, ALTER, DROP, etc, all statements with a semicolon (;) end.
ANALYZE; or ANALYZE database_name; or ANALYZE database_name.table_name;
SELECT column1, column2 /en/en columnN FROM table_name WHERE CONDITION-1 {AND | OR} CONDITION-2;
ALTER TABLE table_name ADD COLUMN column_def /en.;
ALTER TABLE table_name RENAME TO new_table_name;
ATTACH DATABASE 'DatabaseName' As 'Alias-Name';
BEGIN; or BEGIN EXCLUSIVE TRANSACTION;
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name BETWEEN val-1 AND val-2;
COMMIT;
CREATE INDEX index_name ON table_name (column_name COLLATE NOCASE);
CREATE UNIQUE INDEX index_name ON table_name (column1, column2, /en. columnN);
CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, /en/en. columnN datatype, PRIMARY KEY (one or more columns) );
CREATE TRIGGER database_name.trigger_name BEFORE INSERT ON table_name FOR EACH ROW BEGIN stmt1; stmt2; /en/en END;
CREATE VIEW database_name.view_name AS SELECT statement /en/en;
CREATE VIRTUAL TABLE database_name.table_name USING weblog (access.log); or CREATE VIRTUAL TABLE database_name.table_name USING fts3 ();
COMMIT;
SELECT COUNT (column_name) FROM table_name WHERE CONDITION;
DELETE FROM table_name WHERE {CONDITION};
DETACH DATABASE 'Alias-Name';
SELECT DISTINCT column1, column2 /en/en columnN FROM table_name;
DROP INDEX database_name.index_name;
DROP TABLE database_name.table_name;
DROP INDEX database_name.view_name;
DROP INDEX database_name.trigger_name;
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name EXISTS (SELECT * FROM table_name);
EXPLAIN INSERT statement /en.; or EXPLAIN QUERY PLAN SELECT statement /en.;
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name GLOB {PATTERN};
SELECT SUM (column_name) FROM table_name WHERE CONDITION GROUP BY column_name;
SELECT SUM (column_name) FROM table_name WHERE CONDITION GROUP BY column_name HAVING (arithematic function condition);
INSERT INTO table_name (column1, column2 /en/en columnN) VALUES (value1, value2 /en/en valueN);
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name IN (val-1, val-2, /en. val-N);
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name LIKE {PATTERN};
SELECT column1, column2 /en/en columnN FROM table_name WHERE column_name NOT IN (val-1, val-2, /en. val-N);
SELECT column1, column2 /en/en columnN FROM table_name WHERE CONDITION ORDER BY column_name {ASC | DESC};
PRAGMA pragma_name; For example: PRAGMA page_size; PRAGMA cache_size = 1024; PRAGMA table_info (table_name);
RELEASE savepoint_name;
REINDEX collation_name; REINDEX database_name.index_name; REINDEX database_name.table_name;
ROLLBACK; or ROLLBACK TO SAVEPOINT savepoint_name;
SAVEPOINT savepoint_name;
SELECT column1, column2 /en/en columnN FROM table_name;
UPDATE table_name SET column1 = value1, column2 = value2 /en/en columnN = valueN [WHERE CONDITION];
VACUUM;
SELECT column1, column2 /en/en columnN FROM table_name WHERE CONDITION;