Skip to content

Instantly share code, notes, and snippets.

@zer0her0
Last active August 29, 2015 14:16
Show Gist options
  • Save zer0her0/09ab38defcb733df28e6 to your computer and use it in GitHub Desktop.
Save zer0her0/09ab38defcb733df28e6 to your computer and use it in GitHub Desktop.
ED SQLite clipboard - discontinued use.
SELECT * FROM `all_data` WHERE commodity='Explosives'
$ sqlite3 /Users/ameier/Desktop/Elite/data/edtddb.sqlite
sqlite> .databases
sqlite> .mode csv
sqlite> .output test.txt
sqlite> select * from current_data;
SELECT DISTINCT system FROM current_data;
SELECT DISTINCT station FROM current_data;
SELECT DISTINCT system, station FROM current_data;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment