[CentOS] OT: MySQL Help
Thomas E Dukes
edukes at alltel.net
Wed May 10 01:56:35 UTC 2006
> -----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
>
More information about the CentOS
mailing list