how to find the index for a table 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;