mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar
来源：动视网
责编：小采
时间：2020-11-09 16:37:13
mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar
mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar:mysqlblob select faudit_main_id,GROUP_CONCAT( CONCAT('[', CONCAT_WS('&',FAUDIT_SUB_INDEX, FAUDIT_SRC_FIELD,FAUDIT_DST_FIELD,FAUDIT_ISKEY, FAUDIT_OPT), ']') ) sub_descfrom MIG_AUDITF_SUBgroup by faudit_main_id
导读mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar:mysqlblob select faudit_main_id,GROUP_CONCAT( CONCAT('[', CONCAT_WS('&',FAUDIT_SUB_INDEX, FAUDIT_SRC_FIELD,FAUDIT_DST_FIELD,FAUDIT_ISKEY, FAUDIT_OPT), ']') ) sub_descfrom MIG_AUDITF_SUBgroup by faudit_main_id
mysqlblob
select faudit_main_id,GROUP_CONCAT( CONCAT('[',
CONCAT_WS('&',FAUDIT_SUB_INDEX, FAUDIT_SRC_FIELD,FAUDIT_DST_FIELD,FAUDIT_ISKEY, FAUDIT_OPT),
']') ) sub_desc
from MIG_AUDITF_SUB
group by faudit_main_id
mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar
mysqlGROUP_CONCAT结果是blob类型的，怎么转换成varchar:mysqlblob select faudit_main_id,GROUP_CONCAT( CONCAT('[', CONCAT_WS('&',FAUDIT_SUB_INDEX, FAUDIT_SRC_FIELD,FAUDIT_DST_FIELD,FAUDIT_ISKEY, FAUDIT_OPT), ']') ) sub_descfrom MIG_AUDITF_SUBgroup by faudit_main_id
