select hphm into outfile '/home/data/data_trans_tmp/gcjl_hphm.csv' CHARACTER SET gbk
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
from gcjl_hphm;
以上是指定了字符集gbk,你也可以指定字符集utf8
SELECT ... INTO OUTFILE 指定字符集
最新推荐文章于 2022-11-25 18:34:15 发布