1

How do you avoid adding duplicate entries in SQLite when inserting values?

Right now when I insert, it is adding duplicates.

Improve this question

1 Answer 1

Reset to default
2

You need to add a unique index somewhere on the table to you're inserting rows into:

create unique index mytable_id on mytable (id)

Now if you try to add two rows with the same id to mytable an error will be raised by sqlite.

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

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.