[CentOS] OT: MySQL Help

Alan Sparks asparks at doublesparks.net
Wed May 10 01:37:08 UTC 2006

Thomas E Dukes wrote:
> I ran the following against a table:
> ALTER TABLE `products` ADD INDEX `idx_products_model` ( `products_model` );
> Can this index be removed?  If so, how?

DROP INDEX `idx_products_model`
ALTER TABLE `products` DROP INDEX `idx_products_model`

Alan Sparks, UNIX/Linux Systems Integration and Administration
<asparks at doublesparks.net>

More information about the CentOS mailing list