mysql 查询将users.USER_NAME (0001,002,003)转换成 USER_NAMES(张三,李四,王五)
SELECT SQL_CALC_FOUND_ROWS info.*FROM(
select warn.RECODE,warn.WARN_SYSCODE,SYS_INFO.SYS_NAME,warn.WARN_CONTENT,GROUP_CONCAT(users.USER_NAME)as USER_NAMES, DATE_FORMAT(warn.WARN_TIME,'%Y-%m-%d %H:%i:...
原创
2019-07-25 09:47:39 ·
328 阅读 ·
0 评论