how to check if there is index on table mysql code example Example: mysql show indexes on table SHOW INDEXES FROM table_name;