check the manual that corresponds to your MySQL server version for the right syntax to use near 'lim

最新推荐文章于 2024-07-26 03:47:23 发布

weixin_33728708

最新推荐文章于 2024-07-26 03:47:23 发布

阅读量164

点赞数

原文链接：https://my.oschina.net/u/2294525/blog/1616021

版权

2019独角兽企业重金招聘Python工程师标准>>>

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 'limit 1, 6' at line 1
	sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
	com.mysql.jdbc.Util.getInstance(Util.java:381)

sql写的有问题，在sql结尾多写了一个“；”，建议遇到类似问题，先仔细检查一下sql 的正确性；

转载于:https://my.oschina.net/u/2294525/blog/1616021