关于mysql索引错误,MySQL“索引名称不正确...”错误（唯一外键）

I keep getting an error "Incorrect index name 'f7'" using MySQL and I've narrowed it down to the following:

First I create the table,

CREATE TABLE testTable (

id INTEGER PRIMARY KEY AUTO_INCREMENT,

f7 INTEGER NOT NULL,

FOREIGN KEY (f7) REFERENCES testTable2 (id) ON DELETE CASCADE ON UPDATE CASCADE,

) ENGINE=InnoDB;

And then elsewhere,

ALTER TABLE testTable ADD UNIQUE f7;

This has led me to believe that this has to do with a duplicate index (?) I just can't figure out how to fix it. Many thanks.

解决方案

Give it a name, so it doesn't conflict with the foreign Key index

ALTER TABLE `testtable` ADD UNIQUE INDEX `foo` (`f7`);