UNIQUE combination of 2 fields?

[svar]

Is it possible in Mysql(4.01) with InnoDB to have a table
with say two fields and require that there are no
two rows with the same values of BOTH fields?
(obviously one dumm way is to create a third field declared as unique, that will be a combination or concatenation of some sort of the fields. Any smarter way?)

Thanks, svar

 

[piti]

try this one:
ALTER TABLE tablename ADD UNIQUE newindex (field1, field2)

hope this helps