SQLite3 Cheat Sheet

# Run script on database:
sqlite3 example.db
sqlite> .read create.sql

# Run script on database:
sqlite3 example.db < create.sql

# Run query on database:
sqlite3 example.db 'CREATE TABLE entries(id TEXT, title TEXT, date TEXT, tags TEXT, content TEXT);'

# Delete row where column equals:
sqlite3 wiki.db "DELETE FROM entries WHERE id=20210209145248;"

# Delete row:
DELETE FROM "main"."entries" WHERE _rowid_ IN ('918');

About

I'm a technology professional who's been passionate about computers since my Grandad introduced me to an Intel 386 back in the 90s when I was a kid. Those moments inspired a passion within for technology, and I've been playing around with anything with a circuit board ever since. Whenever I have a moment you can probably find me working on something computer-related, and this is where I like to write about those moments.