minte9
LearnRemember   MYSQL





Rebuild Index 

 
ALTER TABLE <tablename> ENGINE = InnoDB;

Rename key 

 
ALTER TABLE <tablename> DROP KEY article_id;
ALTER TABLE <tablename> ADD KEY article_id2;
http://www.ryannitz.org/tech-notes/2008/12/03/rebuild-an-innodb-table-index http://stackoverflow.com/questions/1463363/how-do-i-rename-an-index-in-mysql



References: