How to delete an index in MySQL
Deleting an index in MySQL is quite simple, one query is enough.
Example:
ALTER TABLE `table_name` DROP INDEX `index_name`;
where:
table_name - table name
index_name - the name of the index to be removed
Deleting an index in MySQL is quite simple, one query is enough.
Example:
ALTER TABLE `table_name` DROP INDEX `index_name`;
where:
table_name - table name
index_name - the name of the index to be removed
Comments