UNIQUE keys

[thegman]

Is it possible to make a two UNIQUE keys in a MySQL table which work together? i.e. I have two fields in a table, either one can be the non-unique in different records, but not at the same time.

so in programming terms, it's like saying

if (Value1 is unique AND Value2 is unique) {
CANNOT MAKE RECORD
} else {
MAKE RECORD
}

If you see what I mean.

 

[devnull22]

do you meant this ?

CREATE TABLE blaa(
first_name varchar(25) NOT NULL,
last_name varchar(25) NOT NULL,
blaa varchar(255),
primary key (first_name,last_name)
)

persons can have same first name or same last name but
not same both names.

cheers devnull22

http://www.kbcenter.com

(Knowledge Base Center )

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[thegman]

Exactly! Thanks a lot

Garry