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

问题描述

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

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

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