minte9
SoftwareDevelopment / 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





Questions and answers:
Clink on Option to Answer




1. Rebuild index page_id

  • a) ALTER TABLE catg {{ENGINE}} = InnoDB;
  • b) ALTER TABLE catg {{RESET INDEX}} page_id;

2. Rename key

  • a) ALTER TABLE catg {{DROP KEY}} article_id;
  • b) ALTER TABLE catg {{CHANGE KEY}} article_id article_id2;


References: