sqlite3 usage

open .db file

sqlite3 table.db

print all table (no `;`)

.table

print table content (sql sentence need end with `;`)

select * from table;

print table structure

.schema table

delete a row by a key

delete from table where id=='1';

quit sqlite

.quit