页次: 1
直接删除
alter table 表的名字 drop index 字段的名字;
示例
mysql> create table tb_1 ( name varchar(2) unique); Query OK, 0 rows affected (0.33 sec) mysql> desc tb_1; +-------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------+------+-----+---------+-------+ | name | varchar(2) | YES | UNI | NULL | | +-------+------------+------+-----+---------+-------+ 1 row in set (0.01 sec) mysql> alter table tb_1 drop index name; Query OK, 0 rows affected (0.12 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc tb_1; +-------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------+------+-----+---------+-------+ | name | varchar(2) | YES | | NULL | | +-------+------------+------+-----+---------+-------+ 1 row in set (0.01 sec)
ipbbs.net
离线
页次: 1