What is the difference between CREATE INDEX and ALTER TABLE ADD INDEX?
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.