What is the difference between “ADD KEY” and “ADD INDEX” in MySQL? [duplicate] September 9, 2023 by Tarik KEY is a synonym for INDEX. … | ADD {INDEX|KEY} [index_name] … Check the MySQL documentation for ALTER TABLE.