刚刚在phpmyadmin 添加了几个索引,现在删除不了了,咋办?
程序员文章站
2022-05-03 20:16:32
...
刚刚在phpmyadmin 添加了几个索引,现在删除不了了,咋办?
用了“ALTER TABLE `mayi_record` DROP INDEX ( `adddate` , `adddate1` , `adddate2` );”语句
提示:
#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
哈哈,我终于找到宝藏了。。。
谢谢,最近在看学习索引。非常感谢。
用了“ALTER TABLE `mayi_record` DROP INDEX ( `adddate` , `adddate1` , `adddate2` );”语句
提示:
#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
回复讨论(解决方案)
你看你的图,最左下角还有个 +索引,点一下就别有洞天了!
你看你的图,最左下角还有个 +索引,点一下就别有洞天了!
哈哈,我终于找到宝藏了。。。
ALTER TABLE `mayi_record` DROP INDEX indexname ( `adddate` , `adddate1` , `adddate2` );
ALTER TABLE `mayi_record` DROP INDEX indexname ( `adddate` , `adddate1` , `adddate2` );
谢谢,最近在看学习索引。非常感谢。
上一篇: 遍历python字典几种方法总结
下一篇: php 保留小数点_php技巧