SET @@GROUP_CONCAT_MAX_LEN=-1;
SELECT
GROUP_CONCAT(DISTINCT PHONE)
FROM
_info AS a
WHERE
LENGTH(PHONE) = 11
and a.DEL_FLG = 'UN_DEL'
into outfile 'd:/crm_phone_12_6.txt'
mysql列字段合并,并写入文件
SET @@GROUP_CONCAT_MAX_LEN=-1;
SELECT
GROUP_CONCAT(DISTINCT PHONE)
FROM
_info AS a
WHERE
LENGTH(PHONE) = 11
and a.DEL_FLG = 'UN_DEL'
into outfile 'd:/crm_phone_12_6.txt'
mysql列字段合并,并写入文件