MySQL: Show Unique key definition by name I get the following error: 

ERROR 1062 (23000) at line 1901: Duplicate entry '3-3820-50-0' for key
 'UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID'


How can I find out which table and columns this is referring to?
This should do it:

select table_schema, table_name, column_name
from information_schema.key_column_usage
where constraint_name = 'UNQ_CAT_CTGR_ENTT_DTIME_ENTT_TYPE_ID_ENTT_ID_ATTR_ID_STORE_ID'
order by ordinal_position