how to show index mysql code example Example 1: mysql show indexes on table SHOW INDEXES FROM table_name; Example 2: show indexes mysql SHOW INDEX FROM yourtable;