What is the key type "MUL" in the output of a Describe command?

[kmonsees]

Can some explain what the different options of keys that are in MySQL? I'm assuming that "PRI" is primary, but what is "MUL"? Thanks.

Also, is anyone aware of good sites for MySQL administation scripts....ie (row counts for all tables in a database; a describe script that loops through all tables in a database....)

 

[danielhozac]

MUL means multiple (I assume), like if a field is unique it would get a MUL in the key field.
For your second question, I guess phpMyAdmin is what you want.
//Daniel