[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?
>   

Maybe
DROP INDEX `idx_products_model`
or
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