To start shell


To create database and enter shell

sqlite3 dbname

List tables


To run select from table

select * from some_table;

Delete from table

delete from some_table;

Import data from file into table with default separator ','

.import /path/to/file table_name

To change separator

.separator "\t"

Create table

create table table_name (id int primary key, name varchar(256));