Hi Binns,
If i execute the command "SELECT COUNT (*) FROM table;" how
i will get the return value i.e., number of records in the table ?
Regards,
BhaskarReddy
Roger Binns wrote:
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 18/01/12 23:47, bhaskarReddy wrote:
>> Is there an SQLite API for counting number of records in a table.
>
> No, but that is because regular SQL will do the trick:
>
> SELECT COUNT(*) FROM table;
>
> Roger
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
>
> iEYEARECAAYFAk8Xy+QACgkQmOOfHg372QSJsgCgmzxiQMxaQPz+PkTZvLmvhE0h
> R+kAn0G547GDzO1OrPf8Cn9b+d670WAr
> =hEiw
> -----END PGP SIGNATURE-----
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
--
View this message in context:
http://old.nabble.com/SQLite-API-for-counting-number-of-records-in-a-table.-tp33166164p33166535.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
