如何删除特定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.
相关文章