SQL 和Mongo 对比图表

最新推荐文章于 2022-01-25 13:52:46 发布

iteye_5495

最新推荐文章于 2022-01-25 13:52:46 发布

阅读量84

点赞数

分类专栏： NoSQL 文章标签： php json javascript ViewUI

本文链接：https://blog.csdn.net/iteye_5495/article/details/82445660

版权

NoSQL 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

参看官方说明：

http://www.mongodb.org/display/DOCS/SQL+to+Mongo+Mapping+Chart

MySQL executable	Oracle executable	Mongo executable
mysqld	oracle	mongod
mysql	sqlplus	mongo
MySQL term	Mongo term/concept
database	database
table	collection
index	index
row	BSON document
column	BSON field
join	embedding and linking
primary key	_id field
group by	aggregation

MongoDB queries are expressed as JSON (BSON ) objects. The following chart shows examples as both SQL and in Mongo Query Language syntax.

The query expression in MongoDB (and other things, such as index key patterns) is represented as JSON (BSON). However, the actual verb (e.g. "find") is done in one's regular programming language; thus the exact forms of these verbs vary by language. The examples below are Javascript and can be executed from the mongo shell .

SQL Statement	Mongo Statement
CREATE TABLE USERS (a Number , b Number )	implicit; can also be done explicitly with db.createCollection( "mycoll" )

ALTER TABLE users ADD ...	implicit

INSERT INTO USERS VALUES(3,5)	db.users.insert({a:3,b:5})

SELECT a,b FROM users	db.users.find({}, {a:1,b:1})
SELECT * FROM users	db.users.find()
SELECT * FROM users WHERE age=33	db.users.find({age:33})
SELECT a,b FROM users WHERE age=33	db.users.find({age:33}, {a:1,b:1})
SELECT * FROM users WHERE age=33 ORDER BY name	db.users.find({age:33}).sort({name:1})
SELECT * FROM users WHERE age>33	db.users.find({age:{$gt:33}})
SELECT * FROM users WHERE age!=33	db.users.find({age:{$ne:33}})
SELECT * FROM users WHERE name LIKE "%Joe%"	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<=40	db.users.find({'age':{$gt:33,$lte:40}})
SELECT * FROM users ORDER BY name DESC	db.users.find().sort({name:-1})
SELECT * FROM users WHERE a=1 and b='q'	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=2	db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )
SELECT * FROM users LIMIT 1	db.users.findOne()
SELECT order_id FROM orders o, order_line_items li WHERE li.order_id=o.order_id AND li.sku=12345	db.orders.find({ "items.sku" :12345},{_id:1})
SELECT customer.name FROM customers,orders WHERE orders.id= "q179" AND orders.custid=customer.id	var o = db.orders.findOne({_id: "q179" }); var name = db.customers.findOne({_id:o.custid})

SELECT DISTINCT last_name FROM users	db.users.distinct('last_name')
SELECT COUNT(*y) FROM users	db.users.count()
SELECT COUNT(*y) FROM users where AGE > 30	db.users.find({age: {'$gt': 30}}).count()
SELECT COUNT(AGE) from users	db.users.find({age: {'$exists': true }}).count()

CREATE INDEX myindexname ON users(name)	db.users.ensureIndex({name:1})
CREATE INDEX myindexname ON users(name,ts DESC)	db.users.ensureIndex({name:1,ts:-1})

EXPLAIN SELECT * FROM users WHERE z=3	db.users.find({z:3}).explain()

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 )

DELETE FROM users WHERE z= "abc"	db.users.remove({z:'abc'});

More examples, specifically aggregation examples, here

MongoDB资料汇总专题

1.MongoDB是什么

2.MongoDB内部实现

3.MongoDB实战经验分享

4.MongoDB与开源项目

5.MongoDB客户端与工具集

6.MongoDB应用教程

7.MongoDB性能与优化

8.MongoDB部署、运维与监控

9.MongoDB新闻

iteye_5495

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SQL 和Mongo 对比图表

参看官方说明： http://www.mongodb.org/display/DOCS/SQL+to+Mongo+Mapping+Chart MySQL executableOracle executableMongo executablemysqldoraclemongo...
复制链接

扫一扫