В чём различия между ключевыми словами KEY и INDEX?

[Ямерт]

В чём различия между ключевыми словами KEY и INDEX?

Сабж

 

[Demiurg]

KEY is normally a synonym for INDEX. From version 4.1, the key attribute PRIMARY KEY may also be specified as just KEY. This was implemented for compatibility with other databases. (c) ман

 

[tony2001]

KEY is normally a synonym for INDEX. From version 4.1, the key attribute PRIMARY KEY may also be specified as just KEY. This was implemented for compatibility with other databases.

http://www.mysql.com/doc/en/CREATE_TABLE.html

 

[Ямерт]

Хмм, смотрел ведь эту доку. Глаза надо прочистить.
Прошу прощения.