android - Counting SQLite rows

Question

How to count the number of rows in an SQLite database table? I have a table called my_table and it has columns name info and number.

Answer 1

You may use rawQuery count(*) which returns number of rows in a table.

   cursor=db.rawQuery("Select count(*) from my_table;", null);