问题现象:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
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 'order where o_c_name='哈哈哈'' at line 1
解决思路:
查看错误日志中的报错信息,
near 'order where o_c_name='哈哈哈'' at line 1
起初我检查了很久,sql语句绝对的排查了错误,甚至实体层我都重构了一遍但还是报同样的错误,百思不得其解,实在是苦恼的很。
后来看了网上一篇博文猛然醒悟,原来我的表名order是mysql的内置
字!就像desc等内置字一样在sql语句中出现会发生各种错误!