check if a row exists, if yes, update a column, else, insert a new row SQLITE JAVA ANDROID [duplicate]

Question

Possible Duplicate:
INSERT IF NOT EXISTS ELSE UPDATE?

I want to check if a row (with it's ID) exists in a database, if yes, I want to update the column category, if it does not exist, i want to add a new row. Is this possible via a single query in sqlite (will be applied inside eclipse using java for an android app)

jzafrilla · Accepted Answer · 2012-11-24 12:27:25Z

0

I think that it's not possible. First you have to execute a query to check if a row exist, if yes, execute an update statement, if not, execute an insert statment...i think this are the way to go...

if(existsId(id)){
   updateCategory(categoryValue);
}else{
   addNewRow(newRowData);
}

answered Nov 24, 2012 at 12:27

jzafrilla

1,4363 gold badges18 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

check if a row exists, if yes, update a column, else, insert a new row SQLITE JAVA ANDROID [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related