- .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
Last active
October 1, 2016 00:51
-
-
Save szeitlin/7114f692cc4227573a8e19936cbe10b1 to your computer and use it in GitHub Desktop.
sqlite
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment