解决mysql导出过长数字出现科学计数法

SELECT
	d. NAME AS '企业名称',
	d.a_id,
	aa. NAME AS '区域',
	bs. NAME AS '站点名称',
	bs.x AS '纬度',
	bs.y AS '经度',
	ie.e_id,
	ii.i_id,
   concat('\t',ii.iccid) iccid    --增加制表符 防止导出数据时出现科学计数法
FROM
	d_enterprise d,
	a_area aa,
	b_station bs,
	i_equipment ie,
	i_instrument ii
WHERE
	d.A_ID = aa.A_ID
AND bs.e_id = d.E_ID
AND bs.s_id
AND d.a_id IN (
	'1002'
)
AND ie.s_id = bs.s_id
AND ie.e_id = ii.e_id
and (bs.x='' or ii.iccid ='' or bs.y='' )  --x为空或y为空或iccid为空