I am getting an error as, sqlite> select count (*) from LR6000.ONTtable; Error: no such table: LR6000.ONTtable
Regards, Bhaskar. Simon Slavin-3 wrote: > > > On 30 Jan 2012, at 12:45pm, bhaskarReddy wrote: > >> Is there any API that will return number of rows (records) >> present in a particular table. I want to access the table using its >> database >> name and corresponding table. > > Nope. It's quite difficult doing that in SQLite because of how the data > are stored. The fastest way is to use the API to run > > SELECT COUNT(*) FROM thisTable > > just the same as you would any other SELECT statement. If you have > multiple databases attached then, of course, use > > SELECT COUNT(*) FROM thisDatabase.thisTable > > Simon. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Is-there-any-API-for-counting-number-of-rows-in-a-particular-table.-tp33228856p33228950.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
