MySQL-mysql中create table时创建索引中KEY与INDEX有区别没？

Question

mysql中用SQL语句创建表时，要创建索引时一般都用的是INDEX（aa,bb）什么的，后来又看到另一种方式KEY(aa,bb)。这两种方式效果是一样的嘛？有什么不同么？

KEY(aa,bb)方式

CREATE TABLE `cj_userinfo` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` varchar(20) DEFAULT '' COMMENT 'UID',
  `screen_name` varchar(50) DEFAULT '' COMMENT '昵称',
  `state` tinyint(2) DEFAULT '0' COMMENT '状态默认0未用',
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Answer 1

没有不同.

"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."

http://dev.mysql.com/doc/refman/5.1/en/create-table.html