Read data from SQLite where column name contains spaces

by

For quoting identifiers like table/column names, SQLite supports back ticks for compatibility with MySQL, and square brackets for compatibility with SQL Server, but the portable way is to use double quotes:

SELECT "condition name" FROM library

(Single quotes would be used for string values.)

More Related Contents:

  1. Can’t add parameter ‘this’
  2. How to use an existing database with an Android application [duplicate]
  3. SQlite Getting nearest locations (with latitude and longitude)
  4. Any good ORM tools for Android development? [closed]
  5. Simple export and import of a SQLite database on Android
  6. Foreign key constraints in Android using SQLite? on Delete cascade
  7. SQLite in Android How to update a specific row
  8. Using Singleton design pattern for SQLiteDatabase
  9. Database not copying from assets
  10. Android search with Fragments
  11. Which Android Data Storage Technique to use?
  12. Get generated id after insert
  13. How to persist permission in android API 19 (KitKat)?
  14. Upgrade SQLite database from one version to another?
  15. Android: Cannot perform this operation because the connection pool has been closed
  16. SQLiteOpenHelper failing to call onCreate?
  17. What is the use of BaseColumns in Android
  18. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  19. Android : Table has no column named “variable name” MySql Database error
  20. android.database.sqlite.SQLiteException: no such column
  21. UNIQUE constraint failed: sqlite database : android
  22. How To Test If Cursor Is Empty in a SQLiteDatabase Query
  23. android.database.CursorWindowAllocationException when moving a Cursor
  24. Is it OK to have one instance of SQLiteOpenHelper shared by all Activities in an Android application?
  25. Nothing is populated from ArrayList to ListView
  26. bitmap size exceeds Vm budget error android
  27. Encryption of video files?
  28. Best way to compare dates in Android
  29. InflateException: Binary XML file line #1: Error inflating class caused by OutOfMemoryError
  30. Android: Navigation-Drawer on all activities

Leave a Comment