Having re-jigged the UNIQUE to the proper syntax it does do what I want -
wahey!!
Just to finish this off here is my final table DDL:
CREATE TABLE `WEBSTRINGS` (
`STRINGID` INT NOT NULL AUTO_INCREMENT,
`TOKENID` INT DEFAULT 0,
`LANGID` VARCHAR(30),
`STRINGTEXT` VARCHAR(255),
`PAGEID` TINYINT UNSIGNED DEFAULT 0,
`GUI` TINYINT UNSIGNED DEFAULT 0,
INDEX `indxLANGID` (`LANGID`),
INDEX `indxGUI` (`GUI`),
INDEX `indxTOKENID` (`TOKENID`),
INDEX `indxSTRINGID` (`STRINGID`),
UNIQUE `unqSTRINGID` (`LANGID`,`STRINGTEXT`,`GUI`),
PRIMARY KEY `PrimaryKey` (`STRINGID`)
);
Do I really need the other INDEXes if I have this UNIQUE one set (and a PK)
?
What would be the pluses and minuses of keeping the indexes?
Thanks
Laphan