show indexes for table mysql code example

Example 1: mysql show indexes on table

SHOW INDEXES FROM table_name;

Example 2: show indexes mysql

SHOW INDEX FROM yourtable;