SQLite Syntaxe

SQLite suit un ensemble unique de règles et de directives connu sous le nom de syntaxe. Ce tutoriel répertorie toute la syntaxe SQLite de base et vous fournit une introduction rapide à SQLite.

Sensibilité à la casse

insensible à la cassemais il existe aussi certaines commandes qui sont sensibles à la casse, telles queont des significations différentes dans les instructions SQLite.GLOBetglobCommentaires

Commentaires

Les commentaires SQL commencent par deux caractères "-" consécutifs (ASCII 0x2d) et s'étendent jusqu'au prochain caractère de nouvelle ligne (ASCII 0x0a) ou jusqu'à la fin de l'entrée, selon ce qui se produit en premier.

Vous pouvez également utiliser des commentaires de style C, qui commencent par "/*" et s'étendent jusqu'à la prochaine paire de caractères "*/" ou jusqu'à la fin de l'entrée, selon ce qui se produit en premier. Les commentaires SQLite peuvent s'étendre sur plusieurs lignes.

Instructions SQLite

sqlite>.help -- 这是一个简单的注释

Instructions SQLite

Fin.;Instruction SQLite ANALYZE:

Instruction SQLite ANALYZE:

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

Clause SQLite AND/OR:

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

Instruction SQLite ALTER TABLE:

ALTER TABLE table_name ADD COLUMN column_def...;

Instruction SQLite ALTER TABLE (Renommer):

ALTER TABLE table_name RENAME TO new_table_name;

Instruction SQLite ATTACH DATABASE:

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

Instruction BEGIN TRANSACTION de SQLite :

BEGIN;
or
BEGIN EXCLUSIVE TRANSACTION;

Clause BETWEEN de SQLite :

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

Instruction COMMIT de SQLite :

COMMIT;

Instruction CREATE INDEX de SQLite :

CREATE INDEX index_name
ON table_name ( column_name COLLATE NOCASE );

Instruction CREATE UNIQUE INDEX de SQLite :

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

Instruction CREATE TABLE de SQLite :

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

Instruction CREATE TRIGGER de SQLite :

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

Instruction CREATE VIEW de SQLite :

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

Instruction CREATE VIRTUAL TABLE de SQLite :

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

Instruction COMMIT TRANSACTION de SQLite :

COMMIT;

Clause COUNT de SQLite :

SELECT COUNT(column_name)
FROM   table_name
WHERE  CONDITION;

Instruction DELETE de SQLite :

DELETE FROM table_name
WHERE  {CONDITION};

Instruction DETACH DATABASE de SQLite :

DETACH DATABASE 'Alias-Name';

Clause DISTINCT de SQLite :

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

Instruction DROP INDEX de SQLite :

DROP INDEX database_name.index_name;

Instruction DROP TABLE de SQLite :

DROP TABLE database_name.table_name;

Instruction DROP VIEW de SQLite :

DROP VIEW view_name;

Instruction DROP TRIGGER de SQLite :

DROP TRIGGER trigger_name

Clause EXISTS de SQLite :

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

Instruction EXPLAIN de SQLite :

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

Clause GLOB de SQLite :

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

Clause GROUP BY de SQLite :

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

Clause HAVING de SQLite :

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

Instruction INSERT INTO de SQLite :

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

Clause IN de SQLite :

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

Clause Like de SQLite :

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

Clause NOT IN de SQLite :

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

Clause ORDER BY de SQLite :

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

Instruction PRAGMA de SQLite :

PRAGMA pragma_name;

For example:

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

Instruction RELEASE SAVEPOINT de SQLite :

RELEASE savepoint_name;

Instruction REINDEX de SQLite :

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

Instruction ROLLBACK de SQLite :

ROLLBACK;
or
ROLLBACK TO SAVEPOINT savepoint_name;

Instruction SAVEPOINT de SQLite :

SAVEPOINT savepoint_name;

Instruction SELECT de SQLite :

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

Instruction UPDATE de SQLite :

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

Instruction VACUUM de SQLite :

VACUUM;

Clause WHERE de SQLite :

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

Réflexion de l'IA...