SQLite3 and lastrowid

Alexander Gattin xrgtn at yandex.ru
Fri Nov 19 12:14:34 CET 2010


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



More information about the Python-list mailing list