About “_id” field in Android SQLite

by

_id is useful when you are using the enhanced Adapters which make use of a Cursor (e.g. ResourceCursorAdapter). It’s used by these adapters to provide an ID which can be used to refer to the specific row in the table which relates the the item in whatever the adapter is being used for (e.g. a row in a ListView).

It’s not necessary if you’re not going to be using classes which need an _id column in a cursor, and you can also use “as _id” to make another column appear as though it’s called _id in your cursor.

More Related Contents:

  1. Android SQLite data display to ListView
  2. Android :: SQLIte Db don't insert the datas
  3. IN clause and placeholders
  4. Android Database Transaction
  5. Import .csv file to Sqlite in Android
  6. Debugging sqlite database on the device
  7. SQLite Android Database Cursor window allocation of 2048 kb failed
  8. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  9. Bulk Insertion on Android device
  10. Android Sqlite selection args[] with int values
  11. problem about sqlite database, no such table:
  12. SQLite simultaneous reading and writing
  13. update sql database with ContentValues and the update-method
  14. SQLiteDatabase close() function causing NullPointerException when multiple threads
  15. Using the LIMIT statement in a SQLite query
  16. sqlite encryption for android
  17. Android quotes within an sql query string
  18. Retrieve large blob from Android sqlite database
  19. Android SQLite rawquery parameters
  20. Saving ArrayLists in SQLite databases
  21. How to convert milliseconds to date in SQLite
  22. Backup/restore sqlite db in android [duplicate]
  23. difference between rawquery and execSQL in android sqlite database
  24. Browse SQLite database from Android Studio [closed]
  25. how to bulk insert in sqlite in android
  26. how to drop database in sqlite?
  27. Get SQLite database from Android app
  28. SQLite database on SD card
  29. Does Android SQLite cursor load all records into memory at once?
  30. When to close db connection on android? Every time after your operation finished or after your app exit

Leave a Comment