--插入数据
db.books.insert([{"_id":ObjectId(),"name":"mongodb"},{"_id":ObjectId(),"name":"node.js"}]);
--生成开始ObjectId()
begin = new Date("2021-09-27 23:52:00").getTime()/1000
begin = begin.toString(16)
begin = begin+ new Array(17).join("0")
--生成结束ObjectId()
end = new Date("2021-09-27 23:54:01").getTime()/1000
end = end.toString(16)
end = end+ new Array(17).join("0")
--查找数据
db.orders.find({
'_id': {
'$gte': ObjectId("5dbe7a545368f69de2b4d36e"),
'$lte': ObjectId("6151e9190000000000000000")
}
}).count()
--按id范围导出
mongoexport -d mock -c orders -f _id,street,city,state,country,zip,phone,name,userId,orderDate,status,shippingFee --csv -o ./user.csv -q '{"_id": {"$gte": {"$oid":"5dbe7a545368f69de2b4d36e"},"$lte": {"$oid":"6151e9190000000000000000"}}}' -u root --authenticationDatabase=admin
