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

SQL Statement 51Testing软件测试网!H\3Hb4G4d7fd

Mongo Query Language Statement 51Testing软件测试网 uYDMU~6`$]h

CREATE TABLE USERS (a Number, b Number)

INSERT INTO USERS VALUES(1,1)51Testing软件测试网s+Nr)v2d t

db.users.insert({a:1,b:1})51Testing软件测试网
y_?Rj1D GF

SELECT a,b FROM users

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

SELECT * FROM users51Testing软件测试网OS{@*JK#i.SBA

db.users.find()

SELECT * FROM users WHERE age=3351Testing软件测试网G6Yr7H#Y

db.users.find({age:33})51Testing软件测试网 x8Ggc6P[ fW

SELECT a,b FROM users WHERE age=3351Testing软件测试网&D|#X%jKK p[

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

SELECT * FROM users WHERE age=33 ORDER BY name51Testing软件测试网Mj?M
[1nR$\

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

SELECT * FROM users WHERE age>3351Testing软件测试网?0mE%EB Y+g

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

SELECT * FROM users WHERE age<3351Testing软件测试网 X4H|EpcyXd

db.users.find({'age':{$lt:33}})})51Testing软件测试网f"B?QRT%D$N

SELECT * FROM users WHERE name LIKE "%Joe%"51Testing软件测试网 N'L |P8Y5rM G:Qg

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

SELECT * FROM users WHERE name LIKE "Joe%"

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

SELECT * FROM users WHERE age>33 AND age<=4051Testing软件测试网UtW#C;{kDR`

db.users.find({'age':{$gt:33,$lte:40}})})51Testing软件测试网WM p4V)ZXu

SELECT * FROM users ORDER BY name DESC51Testing软件测试网Q(Zx1f`G

db.users.find().sort({name:-1})51Testing软件测试网1a(c@ Au5|

CREATE INDEX myindexname ON users(name)

db.users.ensureIndex({name:1})

CREATE INDEX myindexname ON users(name,ts DESC)51Testing软件测试网Dgu(_!O.f"l

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

SELECT * FROM users WHERE a=1 and b='q'51Testing软件测试网K1Y&v B"|3\ @

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

SELECT * FROM users LIMIT 10 SKIP 20

db.users.find().limit(10).skip(20)

SELECT * FROM users WHERE a=1 or b=251Testing软件测试网'V1R:o-Vk)_?

db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )

SELECT * FROM users LIMIT 151Testing软件测试网 o8V~ nE

db.users.findOne()51Testing软件测试网gH;q b8o W n

EXPLAIN SELECT * FROM users WHERE z=351Testing软件测试网k]yS;{ d&m

db.users.find({z:3}).explain()51Testing软件测试网BG:G\4vS K|/x/m

SELECT DISTINCT last_name FROM users51Testing软件测试网7x5}ve7cU-e+rn@'o

db.users.distinct('last_name')

SELECT COUNT(*y)51Testing软件测试网4FHek,qGwK7?np

FROM users51Testing软件测试网$rUc"P.T^2n

db.users.count()51Testing软件测试网1^y'g'B8z:i.C7w

SELECT COUNT(*y)

FROM users where AGE > 3051Testing软件测试网
LdF B9z KE:v

db.users.find({age: {'$gt': 30}}).count()51Testing软件测试网J(G$P6ng#N ES)b

SELECT COUNT(AGE) from users51Testing软件测试网X9X-xd+B1y

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

UPDATE users SET a=1 WHERE b='q'51Testing软件测试网)o
j0C"}_

db.users.update({b:'q'}, {$set:{a:1}}, false, true)51Testing软件测试网)|i j5[;tD }.A1lC

UPDATE users SET a=a+2 WHERE b='q'51Testing软件测试网WEOmN;Cz

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

DELETE FROM users WHERE z="abc"

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