如何删除特定mysql表字段上的唯一键

How to remove unique key on particular mysql table field(如何删除特定mysql表字段上的唯一键)

问题描述

我在用户名和电子邮件这两个字段中分配了唯一键.我已经执行了这个查询.

I have assigned unique key in two field username and email. I have execute this query.

ALTER TABLE goipmonl_users DROP INDEX username;

DROP INDEX username ON goipmonl_users

显示错误.那么如何从所选字段中删除唯一键.

It's show an error. So how can I remove unique key from selected field.

#1091 - Can't DROP 'username'; check that column/key exists.

我的表中有用户名、电子邮件列.

I have username, email columns in my table.

推荐答案

请找到使用phpMyAdmin从表中删除唯一索引的屏幕截图

Please find the screen shot to delete unique index from table using phpMyAdmin

1- 选择所需的数据库，

1- Select the desired database,

2-然后选择所需的表，

2-then select the desired table,

3 单击结构"选项卡，选择关系视图"；表格顶部的选项，

3-click on the Structure tab, select the "Relation View" option at the top of the table,

4- 最后是页面底部的索引选项.

4- and finally the Indexes option at the bottom of the page.

这篇关于如何删除特定mysql表字段上的唯一键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！