how can we avoid duplicate values in mysql database

Question

I am storing number of check boxes with delete ,add,view options in database, if you check on that options,it storing some values.But if i click again that will store again and again. how to avoid this duplicate values

database table structure??? where is it? – Muhammad Raheel Dec 12 '13 at 09:18 — Muhammad Raheel, Dec 12 '13 at 09:18

score 0 · Answer 1 · answered Dec 12 '13 at 09:21

0

You can set the column containing unique value as UNIQUE or do a condition :

if SELECT Query return this value , don't insert , else insert.

answered Dec 12 '13 at 09:21

Charaf JRA

8,249
1
34
44

how can we avoid duplicate values in mysql database

1 Answers1