CREATE TABLE table_name (
column_name [NULL|NOT NULL][DEFAULT default_value] [AUTO_INCREMENT] [PRIMARY KEY] [reference definition]...);
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)
mysql>
mysql> show keys from Employee;
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Employee | 1 | myIndex | 1 | id | A | NULL | NULL | NULL | | BTREE | |
+----------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
1 row in set (0.00 sec)
mysql>
mysql> drop table Employee;
Query OK, 0 rows affected (0.00 sec)
mysql>