original source:
I was looking for a SQLite cheat sheet. Then I found this.
I have pushed the cheat sheet to this repository, so that I can use it easily.
I’ll update it as my needs.
SQLite cheat sheet lists the most common SQLite statements that help you work with SQLite more quickly and effectively.
sqlite3 database_name.db
ATTACH DATABASE file_name AS database_name;
.databases
VACCUM
CREATE TABLE [IF NOT EXISTS] table(
primary_key INTEGER PRIMARY KEY,
column_name type NOT NULL,
column_name type NULL,
...
);
ALTER TABLE table_name RENAME TO new_name;
ALTER TABLE table ADD COLUMN column_definition;
ALTER TABLE table DROP COLUMN column_name;
DROP TABLE [IF EXISTS] table_name;
.tables
CREATE [UNIQUE] INDEX index_name
ON table_name (c1,c2,...)
DROP INDEX index_name;
CREATE INDEX index_name ON table_name(expression);
SELECT * FROM table_name;
SELECT c1, c2
FROM table_name;
SELECT DISTINCT (c1)
FROM table_name;
SELECT *
FROM table_name
WHERE condition;
SELECT c1 AS new_name
FROM table_name;
SELECT *
FROM table_name_1
INNER JOIN table_name_2 ON condition;
SELECT *
FROM table_name_1
LEFT JOIN table_name_2 ON condition;
SELECT COUNT (*)
FROM table_name;
SELECT c1, c2
FROM table_name
ORDER BY c1 ASC [DESC], c2 ASC [DESC],...;
SELECT *
FROM table_name
GROUP BY c1, c2, ...;
SELECT c1, aggregate(c2)
FROM table_name
GROUP BY c1
HAVING condition;
INSERT INTO table_name(column1,column2,...)
VALUES(value_1,value_2,...);
INSERT INTO table_name(column1,column2,...)
VALUES(value_1,value_2,...),
(value_1,value_2,...),
(value_1,value_2,...)...
UPDATE table_name
SET c1 = v1,
...
UPDATE table_name
SET c1 = v1,
...
WHERE condition;
DELETE FROM table;
DELETE FROM table
WHERE condition;
SELECT * FROM table
WHERE column LIKE '%value%';
SELECT *
FROM table
WHERE table MATCH 'search_query';