As I was discussing this last tip using a simile loop in SQLite to populate data entry http://blogmymix.blogspot.com/2017/06/sqlite-using-table-to-loop.html

A comment was made that the tRange table was not absolutely necessary
as the following command would suffice:

insert into tTarget(i) select ('My test without tRange: ' || tIndex.id) from tIndex where tIndex.id <=10000 ;

or with proper formatting

insert into tTarget(i)
select ('My test without tRange: ' || tIndex.id)
from tIndex where tIndex.id <=10000 ;

Labels: database, loop, populating data, sqlite, tips