how to avoid from insert duplicate values?

Question

i have a simple project which project give person information to database (sqlite) now i want to avoid from insert duplicate value(by name) what i cant do about it ? thank you guys

As mentioned above creating unique constraint in first step. Next important step is having a validation in app code to tell the user that name already exists in database before even inserting. — Pரதீப், Jul 12 '17 at 07:22
i found it making a index like this : "CREATE UNIQUE INDEX name_index ON Course(CourseName);"; — White Druid, Jul 12 '17 at 08:50

score 1 · Answer 1 · answered Jul 12 '17 at 07:28

1

Just assign UNIQUE to name column. But my suggestion is never set UNIQUE on name column because there are plenty of chances to have same name for more people. Set UNIQUE constraint to another column like ID, email, phone etc.

answered Jul 12 '17 at 07:28

blb007

15
8

score 0 · Answer 2 · answered Jul 12 '17 at 07:22

0

You have two options add Name as primary key or check if the name exist before each insert.

SELECT count(*) FROM "table_name" WHERE name = "name"

If it return > 0 don't make the insert.

answered Jul 12 '17 at 07:22

solamente

266
2
15

i have one primary key and have a lot of names – White Druid Jul 12 '17 at 07:23

how to avoid from insert duplicate values?

2 Answers2