Skip to content

Instantly share code, notes, and snippets.

@feliperomero3

feliperomero3/sqlite3.cmd

Last active August 6, 2022 21:54
Show Gist options
  • Save feliperomero3/f18b73316d5a43d4442be6fce67abeca to your computer and use it in GitHub Desktop.
Save feliperomero3/f18b73316d5a43d4442be6fce67abeca to your computer and use it in GitHub Desktop.
Download ZIP
Sqlite3 CLI commands
Raw
sqlite3.cmd
REM Export table to CSV file
sqlite3 -header -csv "backup 2022-03-14 173525.mdb" "SELECT * FROM transactions" > "transactions.csv"
REM Get schema information
sqlite3 -header -csv "backup 2022-03-14 173525.mdb" "PRAGMA table_info(transactions)"
REM Do this to enter Sqlite "REPL" or "interactive" mode (exit with .exit)
sqlite3 "backup 2022-03-14 173525.mdb"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment