mysql - mysql内部连接出现sql错误

Question

String sql = "set @row \\:=-1; SELECT ue.id, ue.Latitude, ue.Longitude, ue.Serving_Cell, ue.RSCP 
FROM ue INNER JOIN(
     SELECT id 
     from (
          SELECT @row \\:=@row+1 as rownum, id 
          from (
          select id from ue order by id) as sorted
                )as ranked  
      where rownum %20=0) as subset 
      on subset.id = ue.id 
where Operator like :operator ";

Query query = getSessionFactory().getCurrentSession().createSQLQuery(sql);

query.setParameter("operator", "%" + operator + "%");

return query.list();

请帮我找到我的sql错误控制台渲染我:严重:路径 [/SpringSecurity] 上下文中 servlet [mvc-dispatcher] 的 Servlet.service() 抛出异常 [请求处理失败；嵌套异常是 org.hibernate.exception.SQLGrammarException: 无法提取 ResultSet] 其根本原因com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:您的 SQL 语法有错误； 检查与您的 MySQL 服务器版本相对应的手册，了解在“SELECT ue.id, ue.Latitude, ue.Longitude, ue.Serving_Cell, ue.RSCP FROM ue INNER ”附近使用的正确语法第 1 行

Answer 1

您尝试同时执行 2 个查询。您一次只能执行一个。

SELECT ue.id, ue.Latitude, ue.Longitude, ue.Serving_Cell, ue.RSCP 
FROM ue INNER JOIN(
     SELECT id 
     from (
          SELECT @row \\:=@row+1 as rownum, id 
          from (
          select id, @row 
          from ue, (select @row := -1) r
          order by id) as sorted
                )as ranked  
      where rownum %20=0) as subset 
      on subset.id = ue.id 
where Operator like :operator

但是您可以使用子查询来初始化这样的变量

(select @row := -1) r