import csv(mysql)

mysql> load data local infile "path/to/import.csv" into table table_name fields terminated by ',';

mysql> select * from table_name into outfile "path/to/export.csv" fields terminated by ',';

ref:Knowledge Database IT