Monday, August 3, 2015

Sqlite Commands

sqlite3 /path/to/file/wall_test_test.db

Desc Table:
PRAGMA table_info([store_workspace]);
select * from store_workspace;

Delete rows from table:
delete from store_workspace;

List all tables:
.tables;