how to get the index name in mysql code example

Example 1: show indexes mysql

SHOW INDEX FROM yourtable;

Example 2: how to see which columns are indexxed mysql

SHOW INDEXES FROM table_name;