I have just added several indexes to phpmyadmin and cannot delete them now. what should I do? I have just added several indexes to phpmyadmin and cannot delete them now. what should I do?
The "alter table 'mayi _ record' drop index ('adddate', 'adddate1', 'adddate2');" statement is used.
Tip:
#1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '('adddate', 'adddate1 ', 'adddate2') 'at line 1
Reply to discussion (solution)
You can see that there is a + index in the bottom left corner of your graph. click it to find a new index!
You can see that there is a + index in the bottom left corner of your graph. click it to find a new index!
Haha, I finally found the treasure...
Alter table 'mayi _ record' drop index indexname ('adddate', 'adddate1', 'adddate2 ');
Alter table 'mayi _ record' drop index indexname ('adddate', 'adddate1', 'adddate2 ');
Thank you for reading the Learning Index recently. Thank you very much.
