what is the difference between key and index in mysql?
While an index is a structure that is stored in database, keys are strictly a logical concept. Index help us in fast accessing a record, whereas keys just identify the records uniquely. Every table will necessarily have a key, but having an index is not mandatory.