mysql> mysql> mysql> CREATE TABLE Employee (id int NOT NULL,KEY myIndex(id)); Query OK, 0 rows affected (0.03 sec)
mysql> mysql> desc Employee; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | id | int(11) | NO | MUL | | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec)