Updating records 1 to n on an SQLite table

[ichabod801]

Is there some reason you are using SQL for this? This sort of thing I would process in memory rather than in a database.

If you have to use SQL for some reason, I use an auto increment column. Then you can add however much data you need to, and then do one mass delete after adding data based on the value of the auto increment column.