sql语法和MongoDB语法的对应关系

SQL Statement 

Mongo Query Language Statement 

CREATE TABLE USERS (a Number, b Number)51Testing软件测试网/r&? _l K9cr5nZ

INSERT INTO USERS VALUES(1,1)51Testing软件测试网G-~E?0Kt;I^!a

db.users.insert({a:1,b:1})51Testing软件测试网n.bT2]3W(Z4`

SELECT a,b FROM users

db.users.find({}, {a:1,b:1})

SELECT * FROM users

db.users.find()51Testing软件测试网9Igs%@ty@u

SELECT * FROM users WHERE age=33

db.users.find({age:33})51Testing软件测试网{/\6WSB
g

SELECT a,b FROM users WHERE age=3351Testing软件测试网tXoy4v
kH

db.users.find({age:33}, {a:1,b:1})

SELECT * FROM users WHERE age=33 ORDER BY name51Testing软件测试网_BGp{{)J

db.users.find({age:33}).sort({name:1})51Testing软件测试网s7Z4u tOn

SELECT * FROM users WHERE age>3351Testing软件测试网x$JO-S;W)d$dM r

db.users.find({'age':{$gt:33}})})51Testing软件测试网(HmK9K ude|vl

SELECT * FROM users WHERE age<33

db.users.find({'age':{$lt:33}})})51Testing软件测试网\ Nxm2ts

SELECT * FROM users WHERE name LIKE "%Joe%"51Testing软件测试网!Xp ~Ut4dw3]s

db.users.find({name:/Joe/})

SELECT * FROM users WHERE name LIKE "Joe%"51Testing软件测试网*d*D
_aMki

db.users.find({name:/^Joe/})

SELECT * FROM users WHERE age>33 AND age<=4051Testing软件测试网9U@P#s9VY5uz(i

db.users.find({'age':{$gt:33,$lte:40}})})

SELECT * FROM users ORDER BY name DESC

db.users.find().sort({name:-1})

CREATE INDEX myindexname ON users(name)51Testing软件测试网3T n4E(rQ!d\v"f9D

db.users.ensureIndex({name:1})51Testing软件测试网9T)}6^pM#c

CREATE INDEX myindexname ON users(name,ts DESC)

db.users.ensureIndex({name:1,ts:-1})

SELECT * FROM users WHERE a=1 and b='q'

db.users.find({a:1,b:'q'})51Testing软件测试网6kd)l6MX0I"h

SELECT * FROM users LIMIT 10 SKIP 2051Testing软件测试网"Sa(|;K4RP

db.users.find().limit(10).skip(20)51Testing软件测试网5K@6]tII6](D~ A

SELECT * FROM users WHERE a=1 or b=251Testing软件测试网 h*X!`%Em({m

db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )51Testing软件测试网[ B
K"y(N-Xa-MK

SELECT * FROM users LIMIT 1

db.users.findOne()

EXPLAIN SELECT * FROM users WHERE z=3

db.users.find({z:3}).explain()51Testing软件测试网oq#{]XA/x5e

SELECT DISTINCT last_name FROM users

db.users.distinct('last_name')51Testing软件测试网%n&{Id$r8J

SELECT COUNT(*y)

FROM users

db.users.count()51Testing软件测试网"\z$TDL9FNx.zS0\

SELECT COUNT(*y)51Testing软件测试网Q_5\8MP

FROM users where AGE > 3051Testing软件测试网6]E%S3Y)Vv/i~S6`u

db.users.find({age: {'$gt': 30}}).count()

SELECT COUNT(AGE) from users

db.users.find({age: {'$exists': true}}).count()

UPDATE users SET a=1 WHERE b='q'

db.users.update({b:'q'}, {$set:{a:1}}, false, true)

UPDATE users SET a=a+2 WHERE b='q'

db.users.update({b:'q'}, {$inc:{a:2}}, false, true)51Testing软件测试网Z@7aFix u

DELETE FROM users WHERE z="abc"51Testing软件测试网$]P6M:vS6O

db.users.remove({z:'abc'});