mongodb查询部分满足条件的列
db.tblorders.createIndex( { orderid : -1 },{background:true, name:"index_orderid"} ); db.orderlog.dropIndex("index_id"); db.orderlog.find().max({name:"larry"}). use admin; db.runCommand( { renameCollection:"jinri.tblorders_20141111", to: "jinri.tblorders", dropTarget: false } ); db.orderlog.find({},{oid:1,"orderno":1,"createtime":1}).sort({"oid" : -1}).limit(1); db.orderlog.createIndex( { oid : 1 },{background:true, name:"index_oid"} ); ---查询依照OID倒序仅仅查询oid,orderno,createtime字段并返回2行就可以 db.orderlog.find({},{"_id":0,"oid":1,"orderno":1,"createtime":1}).sort({"oid":-1}).limit(2); db.orderlog.find({"oid":"73099840"}); ---查询部分列而且仅仅查询满足条件的部分列 db.OrderLog201512.find({},{"_id":0,oid:1,"orderno":1,"createtime":1},{"orderno" : "20151123010022979562"}).limit(1).forEach(printjson);
posted on 2017-06-13 20:25 yjbjingcha 阅读(1263) 评论(0) 编辑 收藏 举报