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 ;
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 ;
No comments:
Post a Comment