duplicate key name 'pcs_stats_idx' mysql code example

Example: Duplicate key name 'fk_

SELECT U.*, UP.name
FROM units U
LEFT JOIN units UP ON U.parent_id = UP.id