see the created index in mysql code example
Example 1: mysql show indexes on table
SHOW INDEXES FROM table_name;
Example 2: show indexes mysql
SHOW INDEX FROM yourtable;
SHOW INDEXES FROM table_name;
SHOW INDEX FROM yourtable;