mysql拼接多条查询结果并且加序列

    SELECT GROUP_CONCAT(a.DESCRIPTION SEPARATOR '\n')
    FROM (SELECT (@rowNum :=0) AS rowNo,CONCAT('公司内部来文：','\n',
          GROUP_CONCAT((@rowNum:=@rowNum+1),DESCRIPTION,CHAR(13),'\n' SEPARATOR '\n')) DESCRIPTION
          FROM pj_pro_receive_file_t
          WHERE receive_file_type = (
      SELECT lookup_code_id FROM fnd_lookup_code_t WHERE lookup_type = 'RECEIVE_FILE' AND lookup_code = 'NBLW')

      AND project_id = 173 AND receive_status = '1' AND DATE_FORMAT(creation_date, '%Y-%m-%d') = DATE_FORMAT(NOW(), '%Y-%m-%d')) a;

java需要转译@rowNum\\:=0

转载于:https://www.cnblogs.com/baobeiqi-e/p/9884771.html