What is the _COUNT column for?
android
Solution
As said in this tutorial:
Every provider can also report the number of records returned as the _COUNT column; its value is the same for all rows.
Here is an example result set for the query in the previous section:
_ID _COUNT NAME NUMBER
44 3 Alan Vain 212 555 1234
13 3 Bully Pulpit 425 555 6677
53 3 Rex Cars 201 555 4433
Problem
Android specifies the super-handy `_id` column in the `BaseColumns` interface, usage of which is very well explained in this question, but what is `_count` for? Count of rows in a directory, what directory? ``` public interface BaseColumns { /** * The unique ID for a row. * <P>Type: INTEGER (long)</P> */ public static final String _ID = "_id"; /** * The count of rows in a directory. * <P>Type: INTEGER</P> */ public static final String _COUNT = "_count"; } ```