mysql实现查询结果导出csv文件及导入csv文件到数据库操作

本文实例讲述了Mysql实现查询结果导出csv文件及导入csv文件到数据库操作。分享给大家供大家参考，具体如下：

mysql 查询结果导出csv文件：

select logtime, operatingsystem, imei
from GameCenterLogs
where
  operatingsystem >= 1 and operatingsystem <=3
group by operatingsystem,imei
into outfile '/tmp_logs/tmp.csv'
fields TERMINATED BY ',' OPTioNALLY ENCLOSED BY '#' LINES TERMINATED BY '\r\n'