SQLite commands for embedded database applications. Basic Commands 1# Create/open database 2sqlite3 mydb.db 3 4# Open in-memory database 5sqlite3 :memory: 6 7# Execute SQL file 8sqlite3 mydb.db < schema.sql 9 10# Dump database 11sqlite3 mydb.db .dump > backup.sql 12 13# Export to CSV 14sqlite3 -header -csv …
Read More