priyaatslm — 2011-06-17T11:21:53-04:00 — #1
I m beginner to the MySQL:D. I m having 5 feilds in my db, and i have used primary key to avoid the duplicate values in a single field. But what i need is, another field s value also must not replicated. So wat can i do to fix tis problem.. Help anyone!!!!
Waiting for the reply...
Thanks in advance
guido2004 — 2011-06-17T11:49:27-04:00 — #2
They are called columns. Just to avoid confusion
One thing you can do is create a unique index on that other column.
ibazz — 2011-06-17T22:50:23-04:00 — #3
if you post your create table statement, we might be able to help further.