Kirk,
You can use the aggregate function count. So if you have a table
called foo, do this,
SELECT COUNT(*) FROM foo;
That'll give you the number of rows in the table.
Denis
On Fri, Aug 27, 2010 at 6:30 AM, Paul Corke <paul.co...@datatote.co.uk>wrote:
> On 26 August 2010 19:02, Kirk Clemons wrote:
>
> > I would like to be able to create an output log of each row. But I
> > need to know how many rows there are in the database unless there is
> > a way to tell sqlite to stop at the end?
>
> Do you just want:
>
> SELECT * FROM myTable
>
> which will return every row and stop at the end.
>
> Paul.
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
