[CentOS] OT: MySQL Help

> -----Original Message-----
> From: centos-bounces at centos.org 
> [mailto:centos-bounces at centos.org] On Behalf Of Alan Sparks
> Sent: Tuesday, May 09, 2006 9:37 PM
> To: CentOS mailing list
> Subject: Re: [CentOS] OT: MySQL Help
> 
> 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`

Thanks for the help.  Wasn't sure if 'DROP' was what I needed to use.  I'm
not that MySQL savy.  I was following a suggestion to speed up a process.
The problems I'm having aren't in the same table and I was was just trying
to cover any changes since the problems began.

I ran mysqlcheck on the database and got an OK on all tables.  Must be
something else.

Thanks!!


> 
> --
> Alan Sparks, UNIX/Linux Systems Integration and 
> Administration <asparks at doublesparks.net>
> 
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>