本文介绍如何使用mongoexport从MongoDB导出数据为CSV格式，并通过MySQL命令将这些数据加载到MySQL数据库中。具体步骤包括配置导出参数、执行导出操作、进入MySQL控制台及加载CSV文件。
导出：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;
导入：先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;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
