wsdtq123的博客

导出：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 c

CREATE PROCEDURE createDate()begin declare indexdate DATE; set indexdate = DATE('2017-01-01'); while indexdate <= DATE('2027-12-31') do insert into ab_date(date) values(indexdate); set