Bài 3: Cú pháp cơ bản trong SQLite - Học SQLite cơ bản

1. Không phân biệt kiểu chữ

2. Comment trong SQLite

sqlite> .help -- This is a single line comment

3. Lệnh trong SQLite

ANALYZE;orANALYZE database_name;orANALYZE database_name.table_name;

SELECT column1, column2....columnNFROM   table_nameWHERE  CONDITION-1 {AND|OR} CONDITION-2;

ALTER TABLE table_name ADD COLUMN column_def...;

ALTER TABLE table_name RENAME TO new_table_name;

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

BEGIN;orBEGIN EXCLUSIVE TRANSACTION;

SELECT column1, column2....columnNFROM   table_nameWHERE  column_name BETWEEN val-1 AND val-2;

COMMIT;

CREATE INDEX index_nameON table_name ( column_name COLLATE NOCASE );

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

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

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

CREATE VIEW database_name.view_name  ASSELECT statement....;

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

COMMIT;

SELECT COUNT(column_name)FROM   table_nameWHERE  CONDITION;

DELETE FROM table_nameWHERE  {CONDITION};

DETACH DATABASE 'Alias-Name';

SELECT DISTINCT column1, column2....columnNFROM   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....columnNFROM   table_nameWHERE  column_name EXISTS (SELECT * FROM   table_name );

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

SELECT column1, column2....columnNFROM   table_nameWHERE  column_name GLOB { PATTERN };

SELECT SUM(column_name)FROM   table_nameWHERE  CONDITIONGROUP BY column_name;

SELECT SUM(column_name)FROM   table_nameWHERE  CONDITIONGROUP BY column_nameHAVING (arithematic function condition);

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

SELECT column1, column2....columnNFROM   table_nameWHERE  column_name IN (val-1, val-2,...val-N);

SELECT column1, column2....columnNFROM   table_nameWHERE  column_name LIKE { PATTERN };

SELECT column1, column2....columnNFROM   table_nameWHERE  column_name NOT IN (val-1, val-2,...val-N);

SELECT column1, column2....columnNFROM   table_nameWHERE  CONDITIONORDER 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;orROLLBACK TO SAVEPOINT savepoint_name;

SAVEPOINT savepoint_name;

SELECT column1, column2....columnNFROM   table_name;

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

VACUUM;

SELECT column1, column2....columnNFROM   table_nameWHERE  CONDITION;