作者:mobiledu2502870687 | 来源:互联网 | 2018-04-26 05:23
selectfaudit_main_id,GROUP_CONCAT(CONCAT('[',CONCAT_WS('&',FAUDIT_SUB_INDEX,FAUDIT_SRC_FIELD,FAUDIT_DST_FIELD,FAUDIT_ISKEY,FAUDIT_OPT),']'))sub_descfromMIG_AUDITF_SUBgroupbyfaudit_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