SQLite Cheat Sheet by fetttobse

CREATE TABLE name (
colname type constr­aints,
colname type constr­aints
)

This will create a new table. For types and constr­aints look right.

INSERT INTO tablename (column2, column4)
VALUES
(data1, data2),
(data3, data4);

You don't have to fill every column of the table. It is often useful to leave out columns with primary keys or default value insertion.

UPDATE tablename
SET column5 = value5
WHERE expres­sion

This will update the given column with the given value, where the expression evaluates true (usually specific primary key).

The ALTER TABLE function is limited in SQLite.

You can either rename the table with:
ALTER TABLE tablename RENAME TO newtab­lename

Or add a new column with:
ALTER TABLE tablename ADD COLUMN column­def­intion

It is not possible to change column defini­tions of existing tables.

SELECT table1.co­lumn1, table.2­co­lumn2,
FROM table1, table2
WHERE expres­sion
ORDER BY table1.co­lumn1 order

The ORDER BY is optional, possible ways to order are ASC (ascen­ding) and DESC (desce­nding).