mysql> SELECT * FROM 8561e2511accc33e757575c920162ffd;
ERROR 1064 (42000): 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 '8561e2511accc33e757575c920162ffd' at line 1
原因链接:
https://mariadb.com/kb/zh-cn/identifier-names/
原因:
这个8561e2511accc33e757575c920162ffd md5值的表名触犯了“以数值开头且后面跟字符"e"的标识符,需要使用引号引用,它们会被解析为浮点数值。” 这条规则
解决方法:
将表名8561e2511accc33e757575c920162ffd加反引号``括起来。
SELECT * FROM `8561e2511accc33e757575c920162ffd`;