Show Menu
Cheatography
  1. Home >
  2. Cheat Sheets >

SQLite Cheat Sheet (DRAFT) by

SQLite datatypes and queries.

This is a draft cheat sheet. It is a work in progress and is not finished yet.

SQLite DataTypes

NULL
NULL
INTEGER
signed; 1, 2, 3, 4, 6, or 8 bytes depending on value
REAL
8 byte FLOAT (IEEE)
TEXT
text; uses database encoding (UTF-8, UTF-16BE or UTF-16LE)
BLOB
saves the input 1:1
 

SQLite Table Queries

CREATE [TEMP|­TEM­PORARY] TABLE
[IF NOT EXISTS]
[database.]tabl­ename (
column defini­tions
);