On Sun, 26 Mar 2017 15:34:22 -0700, petern <[email protected]>
wrote:
> Here is your suggestion with matched brackets and quotes and assuming
> mytable has a column [tablename]:
>
> select eval(printf('create table %s (a,b,c)',tablename)) from mytables;
I think you mean:
eval(printf('create table %s (a,b,c)',(select tablename from mytables)));
It's something that can be done by any host language. No need to implement
that in SQL.
--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
