You have an error in your SQL syntax; check the manual that corresponds to your MySQL server versio

大家帮帮忙 我这个错都忙一天了都不知道怎么错的!
java.sql.SQLException: 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 'as t limit 0,10' at line 1
java.sql.SQLException: 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 'as t limit 0,10' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2998)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2927)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:956)
at com.freebridge.tvsdbConnection.Data.StmtExecSqlGetResultSet(Data.java:174)
at com.freebridge.service.Conplain.complainSearch(Conplain.java:150)
at com.freebridge.action.ComplainAction.complainSearch(ComplainAction.java:114)。。。。。。。。。

你好,你这个明显是mysql中的sql语句报错(an error in your SQL )
错在(near 'as t limit 0,10' )这个附近。我建议把你的sql语句贴出来
温馨提示:答案为网友推荐,仅供参考

相关了解……

你可能感兴趣的内容

大家正在搜

本站内容来自于网友发表,不代表本站立场,仅表示其个人看法,不对其真实性、正确性、有效性作任何的担保
相关事宜请发邮件给我们
© 非常风气网