Android SQLite check if value exists

Question

I have a SQLite Database and insert some data like this, but now I would like to check first if this value is already in the database and only if its not insert it. How I can do this?

myDB = this.openOrCreateDatabase(MY_DB_NAME, MODE_PRIVATE, null);
myDB.execSQL("INSERT INTO " + MY_DB_TABLE + "(db_datum)" 
 +"VALUES ('"+datum.getText().toString()+"');");

Please edit the your question, the inteded behaviour is not clear "... only if its now ...". Do you mean "only if it's not"? — Moog
– Moog, Commented Jul 31, 2011 at 16:39

Community · Accepted Answer · 2017-05-23 11:59:05Z

1

Are you looking for an IF NOT EXISTS statement (that is, if a record doesn't exist then do something, in this case insert a record)? I'm a little confused myself. This may help: IF NOT EXISTS SQLite.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Jul 31, 2011 at 16:53

Ricky

7,9082 gold badges36 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Janjan Over a year ago

Yes I'm looking for an "IF NOT EXISTS" statement but now I have problems to implement this in android. Where I have to set the quotes?

Joe · Accepted Answer · 2011-07-31 16:39:10Z

0

you could do something like this:

 Cursor c = myDB.rawQuery("SELECT * FROM " + MY_DB_TABLE+ " WHERE " + FIELD + "= '" + VALUE + "'");
 if(c == null)
 {
 //doesn't exists therefore insert record.
 }

answered Jul 31, 2011 at 16:39

Joe

8347 silver badges23 bronze badges

2 Comments

Moog Over a year ago

Does not handle concurrent operations, use this instead How to do IF NOT EXISTS in SQLite

Amer Hadi Over a year ago

I think you should use this if(c.getCount() == 0) { //doesn't exists therefore insert record. }

Collectives™ on Stack Overflow

Android SQLite check if value exists

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related