Open sqlite shell under a Django project:

./manage.py dbshell

Don't forget ";" at the end of each query

List tables in database:

.tables;

List columns of the table:

PRAGMA tableinfo (tablename);

Insert:

INSERT INTO COMPANY VALUES (7, 'James', 24, 'Houston', 10000.00 );

Import CSV:

create table test (id integer, datatype_id integer, level integer, meaning text);

.separator ","
.import no_yes.csv test