How to prevent updating duplicate rows in SQLite Database?

Posted by CSharperWithJava on Stack Overflow See other posts from Stack Overflow or by CSharperWithJava
Published on 2010-05-30T13:28:55Z Indexed on 2010/05/30 13:32 UTC
Read the original article Hit count: 221

Filed under:
|

I'm inserting new rows into a SQLite table, but I don't want to insert duplicate rows.

I also don't want to specify every column in the database if possible. I don't even know if this is possible.

I should be able to take my values and create a new row with them, but if they duplicate another row they should either overwrite the existing row or do nothing.

© Stack Overflow or respective owner

Related posts about database

Related posts about sqlite