I have tried the following query to create index but it throws error
ALTER TABLE users ADD INDEX birthday_index ((date_format(birth_date, "%m-%d")))
Asked
Active
Viewed 10 times
0
Nivesh Saharan
- 197
- 1
- 9
-
So what is your question? – Paul Spiegel Jun 08 '20 at 10:18
-
@PaulSpiegel what should I do to make it work – Nivesh Saharan Jun 08 '20 at 10:23
-
You need MySQL 8.0.13 (at least) – Paul Spiegel Jun 08 '20 at 10:23
-
I see, that might be it. Thanks – Nivesh Saharan Jun 09 '20 at 12:13