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.

What does SHOW INDEX FROM mytable tell you after you have executed the ALTER statement? — vhu
– vhu, Commented Jun 23, 2014 at 12:57

Gordon Linoff · Accepted Answer · 2014-06-23 12:42:44Z

1

Here is a correct way to add an index:

create index idx_mytable_createdon on mytable(created_on);

answered Jun 23, 2014 at 12:42

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hence you use the create index statement as in my answer.