tags:

views:

31

answers:

2

If I want one column to be unique, or two, or three?

A: 

You want to apply a unique constriaint:

The UNIQUE constraint uniquely identifies each record in a database table.

Andrew Hare
+4  A: 
ALTER TABLE xx ADD UNIQUE KEY keyname (column1,column2);
Daniel Schneller