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

select logtime, operatingsystem, imeifrom GameCenterLogswhere  operatingsystem >= 1 and operatingsystem <=3group by operatingsystem,imeiinto outfile '/tmp_logs/tmp.csv'fields TERMINATED BY ',' OPTIONALLY ENCLOSED BY '#' LINES TERMINATED BY '/r/n'

load data infile '/tmp_logs/tmp.csv'into table GameCenterDAULogs fields terminated by ',' OPTIONALLY ENCLOSED BY '#' lines terminated by '/r/n'