mysqp select * get index number and key value code example

SHOW INDEX FROM yourtable;