导出mysql表中部分字段迁移到其它数据库

mysql_outfile.md

导出: select tag,counter into OUTFILE '/var/lib/mysql/tags.csv' FIELDS TERMINATED BY ',' FROM tag_counters ORDER BY counter desc;

导入到其它数据库: LOAD DATA INFILE '/Users/eric/Downloads/tags.csv' INTO TABLE tags FIELDS TERMINATED BY ',' (tag, counter);