sqlite3 hot tips

$ sqlite3

I'm in.

Import db:

sqlite> .open $DATABASE_NAME_HERE
sqlite> .open database.db

Useful formatting

Turn on table headers

sqlite> .headers on

Turn on pretty printing

sqlite> .mode column
sqlite> select * from Exercises;
Id          Type        OwnerId     Name         Description         
----------  ----------  ----------  -----------  --------------------
1           1           1           stirring pb  forearm muscle power