SQLite

SQLite

Cheatsheet - Create a new database

sqlite3 test.db "CREATE TABLE example (id INTEGER PRIMARY KEY, name TEXT); INSERT INTO example (name) VALUES ('Alice'), ('Bob');"

Cheatsheet - Open a database

sqlite3 test.db

Cheatsheet - List tables

.tables

Cheatsheet - Show DDL of a table

.schema table_name