On 22 Jan 2020, at 11:44pm, Deon Brewis <de...@outlook.com> wrote:
> Is there any way to get the length of rows in a table / index in sqlite?
Do you mean the count of rows in a table / index ?
SELECT count(*) FROM MyTable
There's no easy fast way to do this because SQLite doesn't keep that number
handy anywhere. It stores the entries in a tree and it would have to manually
count the leaves of the tree.
----
Or do you mean the count of columns in a table / index ?
SELECT * FROM MyTable LIMIT 1
and count the number of columns returned. Or in C
sqlite3_column_count()
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
