Is there a way to alter an index on a table without dropping it and
recreating it?
I have a table containing 4 columns
(col1, col2, col3, col4)
and an index that currently uses 3 of them (not the primary key)
idx = (col1, col2, col3)
I want to change the index to
idx = (col2, col3)
I need to do this the fastest way possible.
I am using 3.23.34 on a
windows machine
Thanks
Roger Karnouk
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
