除了 ALTER TABLE 语句之外，还有哪个语句可用于对现有 MySQL 表的字段应用 UNIQUE 约束？

CREATE UNIQUE INDEX index_name ON table_name(Column_name);

mysql> DESCRIBE TEST5;

+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| ID    | int(11)     | YES  |     | NULL    |       |
| Name  | varchar(两0) | YES|       | NULL    |       |
+-------+-------------+------+-----+---------+-------+

两 rows in set (0.04 sec)

mysql> CREATE UNIQUE INDEX ID_UNQ ON TEST5(ID);
Query OK, 0 rows affected (0.两0 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> DESCRIBE test5;

+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| ID    |  int(11)    | YES  | UNI | NULL    |       |
| Name  | varchar(两0) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+

两 rows in set (0.04 sec)