create and show index on mysql table code example

Example: mysql show indexes on table

SHOW INDEXES FROM table_name;