MySQL query to see all indexes of table ?

To see the index for a specific table use SHOW INDEX:

SHOW INDEX FROM yourtable;