FROM (SELECT (@rowNum:=0) AS rowNo,CONCAT('公司内部来文:',' ',
GROUP_CONCAT((@rowNum:=@rowNum+1),DESCRIPTION,CHAR(13),' ' SEPARATOR ' ')) 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