PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Rebuild Index

 
ALTER TABLE <tablename> ENGINE = InnoDB;
Rename Key    (2/2)

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    
Mysqldump

        A B C D E F
🔔
1/2