SQLite3 and lastrowid
xrgtn at yandex.ru
Fri Nov 19 12:14:34 CET 2010
On Tue, Nov 16, 2010 at 01:52:42PM -0800, Ian
> 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,
More information about the Python-list