【3】MongoDB对MySQL常用的SQL语句对应的实现

MongoDB对MySQL常用的SQL语句对应的实现
[color=blue]——————————————
MySQL:
SELECT * FROM user
Mongo:
db.user.find()
——————————————
MySQl:
SELECT * FROM user WHERE name = 'foobar'
Mongo:
db.user.find({ 'name' : 'foobar' })
——————————————
MySql:
INSERT INTO user ('name','age') VALUES ('foobar',25)
Mongo:
db.user.insert({ 'name' : 'foobar' , 'age' : 25})
——————————————
如果想增加email这一列
MySql:
ALTER TABLE user ...
Mongo:
db.user.insert({ 'name' : 'foobar' , 'age' : 25 , 'email' : 'foo@bar.com' })
——————————————
MySql:
DELETE * FROM user
Mongo:
db.user.remove({})
——————————————
MySql:
DELETE FROM user WHERE age < 30
Mongo:
db.user.remove({ 'age' : {$lt : 30}})
$gt:> ; $gte:>= ; $lt:< ; $lte:<= ; $ne:!=
——————————————
MySql:
UPDATE user SET `age` = 36 WHERE `name` = 'foobar'
Mongo:
db.user.update({ 'name' : 'foobar'} , {$set : { 'age' : 36}})
——————————————
MySQL:
UPDATE user SET `age` = 'age' + 3 WHERE `name` = 'foobar'
Mongo:
db.user.update({ 'name' : 'foobar'} , {$inc : {'age' : 3}})
——————————————
MySQl:
SELECT COUNT(*) FROM user WHERE `name` = 'foobar'
Mongo:
db.user.find({ 'name' : 'foobar'}).count()
——————————————
MySql:
SELECT * FROM user limit 10,20
Mongo:
db.user.find().skip(10).limit(20)
——————————————
MySQl:
SELECT * FROM user WHERE `age` IN (25,35,45)
Mongo:
db.user.find({ 'age' : {$in : [25,35,45]}})
——————————————
MySql:
SELECT * FROM user ORDER BY age DESC
Mongo:
db.user.find().sort({ 'age' : -1})
——————————————
MySQL:
SELECT DISTINCT(name) FROM user WHERE age > 20
Mongo:
db.user.distinct( 'name',{'age' : {$lt : 20}})
——————————————
MySQL:
SELECT name, sum(marks) FROM user GROUP BY name
Mongo:
db.user.group({
key:{'name':true},
cond:{'name':'foo'},
reduce:function(obj,prev){prev.msum += obj.marks;},
initial:{msum : 0}
})
——————————————
MySQL:
SELECT name FROM user WHERE age < 20
Mongo:
db.user.find('this.age < 20' , {name : 1})[/color]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值