mysql index creating issue

Question

I have deleted all the data from an existing table and then trying to alter table using the following query in mysql:

 ALTER TABLE mytable ADD INDEX (created_on);

but nothing seems to working, it just keep running with out any result.

Answer 1

Here is a correct way to add an index:

create index idx_mytable_createdon on mytable(created_on);