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

Databases
1

Hi,

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:

2

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

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

3

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