1

This question already has an answer here:

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)

marked as duplicate by Paul White Apr 2 '16 at 10:37

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

1

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.