Re: [sqlite] A CTE to count the records (rows) for each table

Excerpts from Richard Hipp's message of 2017-03-13 14:47:49 -0400: > On 3/13/17, Marco Silva wrote: > > Hi, > > > > 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 >

[sqlite] A CTE to count the records (rows) for each table

Hi, 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. -- Marco Arthur @ (M)arco Creatives ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] Count connections

Hi, How do we know how many connections a database has ? Is it possible to query it using SQL ? Is there a simple command from the sqlite3 shell client ? -- Marco Arthur @ (M)arco Creatives