insert into p (other) values ('one'),('two'),('three'),('four'); And why did you declare id as 'integer primary key autoincrement'? Do you require the extra overhead/functionality associated with autoincrement or are you just including it because it sounds nice? <https://sqlite.org/autoinc.html>