OT: MySQL Help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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@xxxxxxxxxxxxxxxx>


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux