Mongodb:在mongodb中编写一个sql server查询,并将集合导出到csv文件 [英] Mongodb : write a sql server query in mongodb and export collection to csv file
问题描述
我是mongodb的新手,想要将集合(表)导出到csv文件。我想在mongodb中编写下面的sql server查询。
< pre lang =" SQL"> SELECT Id,Name,Company FROM CompanyDetails WHERE Company in ('Monte Node Bell','Amdocs')ORDER BY Company< / pre>
然后将数据导出到csv文件,字段名称为列标题。
我不知道
< pre lang =" Javascript"> db。 Table1.find()< / pre>
请帮助。
Hi,
I'm new to mongodb and want to export collection (table) to csv file. I want to write the below sql server query in mongodb.
<pre lang="SQL">SELECT Id, Name, Company FROM CompanyDetails WHERE Company in ( 'Monte Node Bell', 'Amdocs') ORDER BY Company </pre>
and then export the data to csv file with field name as column headers.
I have no clue beyond
<pre lang="Javascript">db. Table1.find() </pre>
Please help.
推荐答案
获得csv文件后,请阅读: http://docs.mongodb.org/manual/reference/program/mongoimport/ [ ^ ]
编辑:
如果你想从mongodb导出,请阅读: http://docs.mongodb.org/manual/reference/program/mongoexport/ [ ^ ]
Once you have your csv file, read this : http://docs.mongodb.org/manual/reference/program/mongoimport/[^]
If you want to export from mongodb then read this : http://docs.mongodb.org/manual/reference/program/mongoexport/[^]
这篇关于Mongodb:在mongodb中编写一个sql server查询,并将集合导出到csv文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!