Get Duplicate entries for some Items

I am new to android and working on an android application, I am parsing an xml and then storing data in the DB (SQLite). items i have in xml are basically slideshows. and i am saving individual slides. Sometimes, it happens that i get one slide saved two times with different itemid(PK + autoincrement) but same data in other cloumns.

e:g

1 | www.abc.com | 25

2 | www.abc.com | 25

which should not be saved. i开发者_StackOverflow中文版 cant post original code. any general solutions to avoid that. Thanks in advance.

You can create table with UNIQUE column.And can handle error while inserting.In this case keep 2nd column also unique as you did with your first column