当前位置:Gxlcms > mysql > mongodb将查询结果导出到文件

mongodb将查询结果导出到文件

时间:2021-07-01 10:21:17 帮助过:210人阅读

mongodb将查询结果导出到文件 ./mongoexport -h 127.0.0.1 -d seo -c kw_city -csv -o test1.csv -q {state:ny} -f city,state 注意事项: 在windows的cmd命令行导出linux服务器的数据是不能使用 -q参数的 options: --help produce help message -v [ --verb

mongodb将查询结果导出到文件

./mongoexport -h "127.0.0.1" -d seo -c kw_city -csv -o test1.csv -q '{"state":"ny"}' -f city,state

注意事项:

在windows的cmd命令行导出linux服务器的数据是不能使用 -q参数的

options:

--help produce help message

-v [ --verbose ] be more verbose (include multiple times for more

verbosity e.g. -vvvvv)

--version print the program's version and exit

-h [ --host ] arg mongo host to connect to ( /s1,s2 for sets)

--port arg server port. Can also use --host hostname:port

--ipv6 enable IPv6 support (disabled by default)

-u [ --username ] arg username

-p [ --password ] arg password

--dbpath arg directly access mongod database files in the given

path, instead of connecting to a mongod server -

needs to lock the data directory, so cannot be used

if a mongod is currently accessing the same path

--directoryperdb if dbpath specified, each db is in a separate

directory

-d [ --db ] arg database to use

-c [ --collection ] arg collection to use (some commands)

-f [ --fields ] arg comma separated list of field names e.g. -f name,age

--fieldFile arg file with fields names - 1 per line

-q [ --query ] arg query filter, as a JSON string

--csv export to csv instead of json

-o [ --out ] arg output file; if not specified, stdout is used

--jsonArray output to a json array rather than one object per

人气教程排行