MongoDB命令集合(二)
a_id':10}).count()
// SELECT COUNT(*) FROM test WHERE data_id=10
db.test.find().skip(10).limit(20)
// SELECT * FROM test LIMIT 10,20
db.test.find({'data_id':{$in:[25,35,45]}})
// SELECT * FROM test WHERE data_id IN (25,35,45)
db.test.find().sort({'data_id':-1})
// SELECT * FROM test ORDER BY data_id DESC
db.test.distinct('name',{'data_id':{$lt:20}})
// SELECT DISTINCT(name) FROM test WHERE data_id<20
db.test.group({key:{'name':true},cond:{'name':'foo'},reduce:function(obj,prev){prev.msum+=obj.marks;},initial:{msum:0}})
// SELECT name,SUM(marks) FROM test GROUP BY name
db.test.find('this.data_id<20',{name:1})
// SELECT name FROM test WHERE data_id<20
db.test.insert({'name':'foobar','age':25})
// INSERT INTO test ('name','age') VALUES('foobar',25)
db.test.remove({})
// DELETE * FROM test
db.test.remove({'age':20})
// DELETE test WHERE age=20
db.test.remove({'age':{$lt:20}})
// SELETE test WHERE age<20
db.test.remove({'age':{$lte:20}})
// DELETE test WHERE age<=20
db.test.remove({'age':{$gt:20}})
// DELETE test WHERE age>20
db.test.remove({'age':{$gte:20}})
// DELETE test WHERE age>=20
db.test.remove({'age':{$ne:20}})
// DELETE test WHERE age!=20
db.test.update({'name':'foobar'},{$set:{'age':36}})
// UPDATE test SET age=36 WHERE name='foobar'
db.test.update({'name':'foobar'},{$inc:{'age':3}})
// UPDATE test SET age=age+3 WHERE NAME='foobar'