SQLite Forum

select in order
Login
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>