SQLite Syntax

SQLite Syntax with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite

<< Back to SQLITE

next → ← prev

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:

ANALYZE;
or
ANALYZE database_name;
or
ANALYZE database_name.table_name;

SQLite AND/OR Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION-1 {AND|OR} CONDITION-2;

SQLite ALTER TABLE Statement

Syntax:

ALTER TABLE table_name ADD COLUMN column_def...;

SQLite ALTER TABLE Statement (Rename)

Syntax:

ALTER TABLE table_name RENAME TO new_table_name;

SQLite ATTACH DATABASE Statement

Syntax:

ATTACH DATABASE 'DatabaseName' As 'Alias-Name';

SQLite BEGIN TRANSACTION Statement

Syntax:

BEGIN;
or
BEGIN EXCLUSIVE TRANSACTION;

SQLite BETWEEN Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name BETWEEN val-1 AND val-2;
SQLite COMMIT Statement:
COMMIT;

SQLite CREATE INDEX Statement

Syntax:

CREATE INDEX index_name
ON table_name ( column_name COLLATE NOCASE );

SQLite CREATE UNIQUE INDEX Statement

Syntax:

CREATE UNIQUE INDEX index_name
ON table_name ( column1, column2,...columnN);

SQLite CREATE TABLE Statement

Syntax:

CREATE TABLE table_name(
   column1 datatype,
   column2 datatype,
   column3 datatype,
   .....
   columnN datatype,
   PRIMARY KEY( one or more columns ));

SQLite CREATE TRIGGER Statement

Syntax:

CREATE TRIGGER database_name.trigger_name 
BEFORE INSERT ON table_name FOR EACH ROW
BEGIN 
   stmt1; 
   stmt2;
   ....
END;

SQLite CREATE VIEW Statement

Syntax:

CREATE VIEW database_name.view_name  AS
SELECT statement....;

SQLite CREATE VIRTUAL TABLE Statement

Syntax:

CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
or
CREATE VIRTUAL TABLE database_name.table_name USING fts3( );

SQLite COMMIT TRANSACTION Statement

Syntax:

COMMIT;

SQLite COUNT Clause

Syntax:

 SELECT COUNT(column_name)
FROM   table_name
WHERE  CONDITION;

SQLite DELETE Statement

Syntax:

DELETE FROM table_name
WHERE  {CONDITION};

SQLite DETACH DATABASE Statement

Syntax:

DETACH DATABASE 'Alias-Name';

SQLite DISTINCT Clause

Syntax:

SELECT DISTINCT column1, column2....columnN
FROM   table_name;

SQLite DROP INDEX Statement

Syntax:

DROP INDEX database_name.index_name;

SQLite DROP TABLE Statement

Syntax:

DROP TABLE database_name.table_name;

SQLite DROP VIEW Statement

Syntax:

DROP INDEX database_name.view_name;

SQLite DROP TRIGGER Statement

Syntax:

DROP INDEX database_name.trigger_name;

SQLite EXISTS Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name EXISTS (SELECT * FROM   table_name );

SQLite EXPLAIN Statement

Syntax:

EXPLAIN INSERT statement...;
or 
EXPLAIN QUERY PLAN SELECT statement...;

SQLite GLOB Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name GLOB { PATTERN };

SQLite GROUP BY Clause

Syntax:

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name;

SQLite HAVING Clause

Syntax:

SELECT SUM(column_name)
FROM   table_name
WHERE  CONDITION
GROUP BY column_name
HAVING (arithematic function condition);

SQLite INSERT INTO Statement

Syntax:

INSERT INTO table_name( column1, column2....columnN)
VALUES ( value1, value2....valueN);

SQLite IN Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name IN (val-1, val-2,...val-N);

SQLite Like Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name LIKE { PATTERN };

SQLite NOT IN Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  column_name NOT IN (val-1, val-2,...val-N);

SQLite ORDER BY Clause

Syntax:

SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION
ORDER BY column_name {ASC|DESC};

SQLite PRAGMA Statement

Syntax:

PRAGMA pragma_name;

For example:

PRAGMA page_size;
PRAGMA cache_size = 1024;
PRAGMA table_info(table_name);

SQLite RELEASE SAVEPOINT Statement

Syntax:

RELEASE savepoint_name;

SQLite REINDEX Statement

Syntax:

REINDEX collation_name;
REINDEX database_name.index_name;
REINDEX database_name.table_name;

SQLite ROLLBACK Statement

Syntax:

ROLLBACK;
or
ROLLBACK TO SAVEPOINT savepoint_name;

SQLite SAVEPOINT Statement

Syntax:

SAVEPOINT savepoint_name;

SQLite SELECT Statement

Syntax:

SELECT column1, column2....columnN
FROM   table_name;

SQLite UPDATE Statement

Syntax:

UPDATE table_name
SET column1 = value1, column2 = value2....columnN=valueN
[ WHERE  CONDITION ];

SQLite VACUUM Statement

Syntax:

VACUUM;
SQLite WHERE Clause:
SELECT column1, column2....columnN
FROM   table_name
WHERE  CONDITION;

Next TopicSQLite Data Types

← prev next →

.Net

.NET Array Dictionary List String 2D Async DataTable Dates DateTime Enum File For Foreach Format IEnumerable If IndexOf Lambda LINQ Parse Path Process Property Regex Replace Sort Split Static StringBuilder Substring Switch Tuple

Java

Core Array ArrayList HashMap String 2D Cast Character Console Deque Duplicates File For Format HashSet If IndexOf Lambda Math ParseInt Process Random Regex Replace Sort Split StringBuilder Substring Switch Vector While

TheDeveloperBlog.com

SQLite Syntax

SQLite Syntax

Related Links:

.Net

Java

Related Links