how to remove unique key in mysql

If you need to remove an unique key from my mysql table. How can you remove that using mysql query? There are two methods to remove index in mysql.  One is MySql Query and another is GUI. Second Method to remove using MySql GUI (phpMyAdmin): In this method you have to open GUI interface of MYSQL and then go to that database and then go to that particular table in which you want to remove index. After that click on the structure option, Then you can see table structure and below you can see table indexes. You can remove indexes by clicking on drop option.

If you need to remove an unique key from my mysql table. How can you remove that using mysql query?

There are two methods to remove index in mysql.  One is MySql Query and another is GUI.

First Method to remove using MySql Query:

To know the name of the index you want to delete or update

SHOW INDEX FROM

To delete an index

ALTER TABLE DROP INDEX ;

To add a unique key use :

alter table your_table add UNIQUE(target_column_name);

To add multiple column for a unique key use:

ALTER TABLE ADD UNIQUE( column_name1, column_name2, column_name3);

Second Method to remove using MySql GUI (phpMyAdmin):

In this method you have to open GUI interface of MYSQL and then go to that database and then go to that particular table in which you want to remove index.

After that click on the structure option, Then you can see table structure and below you can see table indexes. You can remove indexes by clicking on drop option