"MUL, is basically an index that is neither a primary key nor a unique key. The name comes from “multiple” because multiple occurences of the same value are allowed. Straight from the MySQL documentation:" cf. -> http://dev.mysql.com/doc/refman/5.7/en/show-columns.html
1
What does "MUL" mean in MySQL for the key?
