MySQL Forums
Forum List  »  MyISAM

Re: Changing column's sequence in index
Posted by: Rick James
Date: December 31, 2009 01:50AM

Assuming you have INDEX `ab` (`a`,`b`) on table `tbl`:
ALTER TABLE tbl
   DROP INDEX ab,
   ADD INDEX (b,a);

I am assuming you mean the order of a and b, when you say 'sequence'; not the SEQUENCE found in Oracle.

Options: ReplyQuote


Subject
Views
Written By
Posted
5879
December 29, 2009 11:27PM
Re: Changing column's sequence in index
2550
December 31, 2009 01:50AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.