mongodb导出数据导入mysql

来源:互联网 发布:python教程3.6.2 编辑:程序博客网 时间:2024/06/06 01:58
导出:mongoexport --port=27000 -d lyric -c lyric --csv -f songName,artistName,content -o lyric_e_1.csv


导入:先mysql -uroot -p进入mysql控制台
再mysql> load data infile "E:/lyric_e_2.csv"  into table song_lyric character set
utf8 fields terminated by "," enclosed by "\""  ignore 1 lines;
原创粉丝点击