mongodb另类导出sql语句操作:
db.getCollection('fsDocument').find().forEach(
function(item){
var sql = "INSERT INTO table (column1,column2,column3) VALUES ('字段1','字段2','"+item.mongoColumn+"');";
print(sql);
}
);
然后把打印出来的语句从控制台粘出来
mongodb另类导出sql语句操作:
db.getCollection('fsDocument').find().forEach(
function(item){
var sql = "INSERT INTO table (column1,column2,column3) VALUES ('字段1','字段2','"+item.mongoColumn+"');";
print(sql);
}
);
然后把打印出来的语句从控制台粘出来