批量更新:
use order_copy;
db.getCollection("zorders").find(
{
"qudao" : "77","pid":120
}
).forEach(
function(item){
db.getCollection('zorders').update({"_id":item._id},{$set:{"nickname": "梁艳聪112233"}})
}
);
查询:
use order_copy;
db.getCollection("zorders").find(
{
"qudao":"77","pid":120,"name":{"$ne":"stephen1"},"age":{"$gte":18, "$lte":40}
}
);
指定字段
db.getCollection("zorders").find(
{
"qudao":"77"
},
{"pid":1,"price":1}
);
删除数据
db.getCollection("zorders").remove(
{
"orderid":"ydtg20180723101347640739"
}
);
新增数据:
db.getCollection("zorders").insert({"orderid":"ydtg20180723102601087513"});
查询条件:
age >= 18 && age <= 40
"age":{"$gte":18, "$lte":40}
name != "stephen1"
"name":{"$ne":"stephen1"}
in ("stephen","stephen1");MongoDB的in list中的数据可以是不同类型
"name":{"$in":["stephen","stephen1",123]}
not in,同时也是$in的取反
"name":{"$nin":["stephen2","stephen1"]}
name = "stephen1" or age = 35;or,$or所针对的条件被放到一个数组中,每个数组元素表示or的一个条件;
"$or": [{"name":"stephen1"}, {"age":35}]
混合使用 $or 和 $in
"$or": [{"name":{"$in":["stephen","stephen1"]}}, {"age":36}]
时间区间查询
"create_time":{"$gte":ISODate("2018-7-23T00:00:00Z"),"$lt":ISODate("2018-7-25T59:59:59Z")}