Two column s values must not be replicted. How it is possible?


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 :slight_smile:

They are called columns. Just to avoid confusion :slight_smile:

One thing you can do is create a unique index on that other column.

if you post your create table statement, we might be able to help further.