sqlite - ku-fpg/blackboard GitHub Wiki
% sqlite3 database.sdb
sqlite> .tables
Dogs Events
sqlite> .headers on
sqlite> .mode column
sqlite> select * from Events;
Id Name Assignment timestamp
---------- ---------- ---------- -------------------
1 Andy H1 2016-01-16 22:25:32
2 A B 2016-01-16 22:45:31
3 A B 2016-01-17 03:09:34