Home >Database >Mysql Tutorial >mysql GROUP_CONCAT结果是blob类型的，怎么转换成varchar
mysql GROUP_CONCAT结果是blob类型的，怎么转换成varchar
- WBOYOriginal
- 2016-06-06 09:41:141993browse
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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql 存储过程中使用了游标和临时表，返回的临时表数据不准确Next article：mysql字段设置某种情况下的特殊值