mysql view columns as index code example
Example 1: show indexes mysql
SHOW INDEX FROM yourtable;
Example 2: how to see which columns are indexxed mysql
SHOW INDEXES FROM table_name;
SHOW INDEX FROM yourtable;
SHOW INDEXES FROM table_name;