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

2018-02-03 10:32:42来源:oschina作者:kumu人点击

分享
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 的正确性;

微信扫一扫

第七城市微信公众平台