Re: SQLite: how to get a number of rows from SELECT query

The DBI documentation states in ->execute for SELECT statements:

The execute method does not return the number of rows that will be returned by the query

So you will have to run a second query to fetch the number of returned rows, or fetch all rows to get their number.

Comment on Re: SQLite: how to get a number of rows from SELECT query Select or Download Code

Replies are listed 'Best First'.
Re^2: SQLite: how to get a number of rows from SELECT query by igoryonya (Pilgrim) on Jul 20, 2021 at 07:33 UTC
Hm, pity. So, it's just MySQL feature, I guess.	[reply]
Re^3: SQLite: how to get a number of rows from SELECT query by Fletch (Bishop) on Jul 20, 2021 at 13:28 UTC
As the documentation mentions (rows of DBI; look for `rows` under statement handle methods if that link doesn't work) it's dependent on the underlying database driver to begin with, not to mention what your query actually does. The DBD documentation may mention the behavior, too. Generally, you can only rely on a row count after a non-`SELECT` execute (for some specific operations like `UPDATE` and `DELETE`), or after fetching all the rows of a `SELECT` statement. The cake is a lie. The cake is a lie. The cake is a lie.	[reply] [d/l] [select]