KEY is normally a synonym for INDEX. The key attribute PRIMARY KEY can also be specified as just KEY when given in a column definition. This was implemented for compatibility with other database systems.
简言之,在MySQL中,INDEX和KEY的概念是一样的。PRIMAR[......]
MySQL中index和key的关系,好冷啊……
2 Replies