On Mon, 17 Nov 2014 12:00:06 +0000
Hick Gunter <[email protected]> wrote:
> SELECT table_name FROM sqlite_master;
>
> And then, in your programming language of choice, execute
Or, with some determination, you can do it in two steps in pure SQL:
Use SQL to produce SQL, and execute the result,
SELECT 'select count(*), '
|| table_name
|| ' from '
|| table_name
|| ' union '
FROM sqlite_master;
To replace the last 'union clause' in the result with a semicolon, you
could sling a string in the application, or use a correlated subquery
(and ORDER BY) to supply ';' when e.g. table_name is max(table_name).
To do it in one fell swoop in SQL, you need a virtual table that will
execute SQL for you. Supply the above as input, and get two columns of
output.
--jkl
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
