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不要求。
没有评论:
发表评论