SQLite Basics
March 22, 2015
Start / Open
code
sqlite3
sqlite3 NAME.db
Meta-Commands
code
.database -- zeigt DB-Datei
.tables -- Tabellen
.schema -- Schema anzeigen
.open NAME.db
.quit
Beispiel
code
CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT);
INSERT INTO users (name) VALUES ('Anna');
SELECT * FROM users;