navicat 导出excel数字为科学计数法问题解决方案

查询sql可以采用在字符串结尾加上制表符"\t"

SELECT
    a.name AS '姓名',
    CONCAT(a.num,'\t')  AS '识别号'
FROM
    student a LIMIT 1000;