Is it possible to apply primary key on the text fields in android database

by

as per the faq of sqlite documentation, using TEXT as a datatype for primary key should work.

i used your query and here it is, the table is created.

CREATE TABLE contacts ( email text primary key not null, name text not null);

INSERT INTO contacts VALUES ('[email protected]', 'sample')
INSERT INTO contacts VALUES ('[email protected]', 'sample')

enter image description here

enter image description here

now here is where it went wrong.

when i ran this again

INSERT INTO contacts VALUES ('[email protected]', 'sample')

nothing happened, no errors.
But it did not update the record. so i conclude data integrity is there but you don’t get any feedback about the failure.

More Related Contents:

  1. Hindi font not displying correctly in android [closed]
  2. Unable to save and retrieve String data using Sqlite in android
  3. Pros and Cons of SQLite and Shared Preferences [closed]
  4. Share SQLite database between 2 android apps?
  5. Android: upgrading DB version and adding new table
  6. How do I view the SQLite database on an Android device? [duplicate]
  7. How to ignore accent in SQLite query (Android)
  8. How to disable the Clear Data button in Application info of Manage application
  9. How to convert image file data in a byte array to a Bitmap?
  10. Store Android SQLite
  11. Does Android Support JDBC
  12. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  13. How to perform an SQLite query within an Android application?
  14. How do I order my SQLITE database in descending order, for an android app?
  15. SQLite Exception no such column when trying to select
  16. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  17. Android SQLite Database, WHY drop table and recreate on upgrade
  18. Android ExpandableListView and SQLite Database
  19. Multiple Table SQLite DB Adapter(s) in Android?
  20. What is The use of moveToFirst () in SQLite Cursors
  21. How to store sqlite database directly on sdcard
  22. Create SQLite database in android
  23. Android SQLite auto increment
  24. Android Device Monitor “data” folder is empty
  25. How to check database on not rooted android device
  26. How to store JSON object in SQLite database
  27. sqlite3: not found
  28. Android SQLiteOpenHelper cannot open database file
  29. Getting the type of a column in SQLite
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment