> > Does anyone knows a Common Table Expression (CTE) to be used with the
> > sqlite_master table so we can count for each table how many rows it
> > has.
I wonder if it's always accurate to piggyback on the work of ANALYZE and
obtain row counts as of the last ANALYZE via:
select tbl, max(substr(stat, 1, instr((stat || ' '), ' ') -1 )) from
sqlite_stat1 group by tbl order by tbl;
Equivalently, if one relies on CAST to obtain the first integer:
select tbl, max(cast (stat AS NUMERIC)) from sqlite_stat1 group by
tbl order by tbl;
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
