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的概念是一样的。PRIMARY KEY要求NOT NULL，其他KEY不要求。
http://www.coder4.com/archives/1317
原文：http://www.cnblogs.com/seasonzone/p/4210930.html