2 fields combination unique in table...

[strucnjak79]

So I need two unique fields in my table, but they should not be unique separately, just a combination of values in this two fields... Let's say I have table with fields book, page, text... I can have more then one book #1, more than one pages #1 but only one combination of book #1 and page #1! But I have page #1 for each book!

How to restrict this in MySQL?

 

[TonyGroves]

Declare a unique index on the combination of the two fields:
[tt]
ALTER TABLE tblname
ADD UNIQUE INDEX bookpageindex (bookfield,pagefield)
[/tt]

 

[strucnjak79]

Simple as that? Tnx!