mysql 创建索引 key,Mysql中创建索引的INDEX和KEY

一、问题

被问到，mysql为什么用key创建索引，而不是index。这个被难住了。

二、查一下

关于key和index只有三个页面，primary key，foreign key和create index。

看来使用index是比较标准的语法。

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.

这篇对话文章，也挺有意思：

In MySQL, KEY is equivalent to INDEX. It won't check for duplicates without UNIQUE in front of it.

Egor

Wednesday, June 16, 2004

Boy, they should really change the name or behavior then, because that's a *big* departure from the relational definition of "KEY".

Captain McFly

Wednesday, June 16, 2004

另外，我们使用index和key分别创建索引，导出的create syntax是一样的。

三、结论

结论：index和key没有区别(即使有区别，也可以忽略)