导出: 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);
导出: 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);