解决You have an error in your SQL syntax; check the manual that corresponds to your MySQL server错误
Exception in thread “main”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 righ
·
Exception in thread “main”
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 user_id=1’ at line 1
它说是sql语句错误,找了很久也没发现,后来再仔细看这个错误,才发现我的表名order与数据库关键字order by重名了!!表名不能与关键字相同!
更多推荐
已为社区贡献1条内容
所有评论(0)