Skip to content

Instantly share code, notes, and snippets.

@szeitlin
Last active October 1, 2016 00:51
Show Gist options
  • Save szeitlin/7114f692cc4227573a8e19936cbe10b1 to your computer and use it in GitHub Desktop.
Save szeitlin/7114f692cc4227573a8e19936cbe10b1 to your computer and use it in GitHub Desktop.
sqlite
  • .help, .quit
  • .headers on to show column names
  • .tables to list all tables and derived views
  • create view view_name as select...
  • .output file_name have to manually toggle back off to stop appending to that file
  • .once file_name to output to a file for only the following command
  • strftime(%m, timecol) as Month to get datetime components
  • A * 1.0/ B to convert int column operations to float output
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment