I have searched the web but I have failed to find a conclusive answer for this question.

Is there any difference between CREATE INDEX and ALTER TABLE ADD INDEX?

Are there any problems that may arise when I use one or the other or do both work the same way?

Server version: 5.5.32 - MySQL Community Server (GPL)


The CREATE INDEX syntax requires an index name, whereas the ALTER TABLE ADD INDEX syntax doesn't.

This question as already been asked and answered and should be marked as a duplicate.

  • I have created an event, but when the execution time reaches, the column in the database is not update. What causes this? – kyadondo timothy Apr 2 '16 at 10:36

Not the answer you're looking for? Browse other questions tagged or ask your own question.