Hello,
I have a table of dot commands and SQL -
sqlite> select sql from tcout1;
sql
.headers off
select '.once tc'||strftime('%s','now'); --first execute this SQL statement
and replace this line with its own result
select * from tc;
Is there a way to execute the contents of certain rows (the second row in
this example) and replace it with its own result to create second table /
view which could interpreted by the sqlite shell?
sqlite> select sql from tcout2;
sql
.headers off
.once tc1515867712
select * from tc;
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users