MySQL 导出CSV文件，长数据低位变为00000的问题

导出CSV表，使用excel或WPS打开后发现数据超过15位的后面全变成了00000；

原来使用的导出语句：

SELECT * INTO OUTFILE '/tmp/test.csv'   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM test.test;

修改后的导出语句：关键点在于将enclosed by 后的分隔符从双引号变成\t；

SELECT * INTO OUTFILE '/tmp/test.csv'   FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\t' LINES TERMINATED BY '\n' FROM test.test;

再打开后不再有低位变成00000的现象。