Re: Row length in SQLITE

On 22 Jan 2020, at 11:44pm, Deon Brewis <[email protected]> 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
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users