SQLite3 and lastrowid

[Alexander Gattin]

Hello,

On Tue, Nov 16, 2010 at 01:52:42PM -0800, Ian
wrote:
> The proper way to get the number of rows is to
> use the COUNT aggregate function, e.g., "SELECT
> COUNT(*) FROM TABLE1", which will return a
> single row with a single column containing the
> number of rows in table1.

It's better to select count(1) instead of
count(*). The latter may skip rows consisting
entirely of NULLs IIRC.

-- 
With best regards,
xrgtn