SQLite3 Cheat Sheet

main.md

Open SQLite3 shell with headers and column mode on:

sqlite3 -column -header your_db.db

Meta Commands

Meta Command	Description
.show	Displays current settings for various parameters
.databases	Provides database names and files
.tables	Show current tables
.quit	Quit
.schema	Show schemas of tables
.headers	Set headers on or off
.mode	Select mode for the output table

Data Types

Create Table

CREATE TABLE comments ( 
	post_id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 
	name TEXT NOT NULL, 
	email TEXT NOT NULL, 
	website_url TEXT NULL, 
	comment TEXT NOT NULL );