重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: MongoDB 只显示指定字段的记录 [打印本页]

作者: 郑全 时间: 2023-10-6 17:02
标题: MongoDB 只显示指定字段的记录

比如employees集合，我们只想显示 empid，name

可以按下面显示：

db.employees.find({},{empid:1,name:1})

> db.employees.find({},{empid:1,name:1});
{ "_id" : ObjectId("64a8e771c531db7498ca2081"), "empid" : 100, "name" : "mhan" }
{ "_id" : ObjectId("64a8e795c531db7498ca2082"), "empid" : 101, "name" : "liuzy" }
{ "_id" : ObjectId("64a8e7e3c531db7498ca2083"), "empid" : 102, "name" : "wjia" }
{ "_id" : ObjectId("64a8e841c531db7498ca2084"), "empid" : 103, "name" : "zyin" }

不想显示：_id

> db.employees.find({},{"_id":0,empid:1,name:1});
{ "empid" : 100, "name" : "mhan" }
{ "empid" : 101, "name" : "liuzy" }
{ "empid" : 102, "name" : "wjia" }
{ "empid" : 103, "name" : "zyin" }
>

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)