ERROR 1061: Duplicate key name 'CategoryID_idx' SQL Statement: ALTER TABLE `db_photor`.`categoryattributemap` ADD INDEX `CategoryID_idx` (`CategoryID` ASC) VISIBLE code example
Example: Duplicate key name 'fk_
SELECT U.*, UP.name
FROM units U
LEFT JOIN units UP ON U.parent_id = UP.id