subject:"\[sqlite\] How to get record count"

Re: [sqlite] How to get record count

2007-12-12 Thread Marco Bambini


SELECT count(*) FROM myTable;

---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/



On Dec 12, 2007, at 2:55 PM, Tom Parke wrote:


How can I get a count of the number of records in a table?
Sqlite3_get_table() might work, but I only need the count, not the
record set.

Thanks,

Tom




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] How to get record count

2007-12-12 Thread Tom Parke

How can I get a count of the number of records in a table?
Sqlite3_get_table() might work, but I only need the count, not the
record set.

Thanks,

Tom