mongodb与SQL对应关系表
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了mongodb与SQL对应关系表,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含3001字,纯文字阅读大概需要5分钟。
内容图文
MongoDB find() Statements
SELECT *
FROM users
db.users.find()
SELECT id,
user_id,
status
FROM users
db.users.find(
{ },
{ user_id:1,status:1 }
)
SELECT user_id,status
FROM users
db.users.find(
{ },
{ user_id:1,status:1,_id:0 }
)
SELECT *
FROM users
WHERE status="A"
db.users.find(
{ status:"A" }
)
SELECT user_id,status
FROM users
WHERE status="A"
db.users.find(
{ status:"A" },
{ user_id:1,status:1,_id:0 }
)
SELECT *
FROM users
WHERE status!="A"
db.users.find(
{ status: {$ne:"A" } }
)
SELECT *
FROM users
WHERE status="A"
AND age=50
db.users.find(
{ status:"A",
age:50 }
)
SELECT *
FROM users
WHERE status="A"
OR age=50
db.users.find(
{ $or: [ {status:"A" } ,
{ age:50 } ] }
)
SELECT *
FROM users
WHERE age>25
db.users.find(
{ age: {$gt:25 } }
)
SELECT *
FROM users
WHERE age<25
db.users.find(
{ age: {$lt:25 } }
)
SELECT *
FROM users
WHERE age>25
AND age<=50
db.users.find(
{ age: {$gt:25,$lte:50 } }
)
SELECT *
FROM users
WHERE user_id like "%bc%"
db.users.find( {user_id:/bc/ } )
SELECT *
FROM users
WHERE user_id like "bc%"
db.users.find( {user_id:/^bc/ } )
SELECT *
FROM users
WHERE status="A"
ORDER BY user_id ASC
db.users.find( {status:"A" } ).sort( {user_id:1 } )
SELECT *
FROM users
WHERE status="A"
ORDER BY user_id DESC
db.users.find( {status:"A" } ).sort( {user_id:-1 } )
SELECT COUNT(*)
FROM users
db.users.count()
or
db.users.find().count()
SELECT COUNT(user_id)
FROM users
db.users.count( {user_id: {$exists:true } } )
or
db.users.find( {user_id: {$exists:true } } ).count()
SELECT COUNT(*)
FROM users
WHERE age>30
db.users.count( {age: {$gt:30 } } )
or
db.users.find( {age: {$gt:30 } } ).count()
SELECT DISTINCT(status)
FROM users
db.users.distinct("status" )
SELECT *
FROM users
LIMIT 1
db.users.findOne()
or
db.users.find().limit(1)
SELECT *
FROM users
LIMIT 5
SKIP10
db.users.find().limit(5).skip(10)
EXPLAIN SELECT *
FROM users
WHERE status="A"
db.users.find( {status:"A" } ).explain()
2. insert插入
SQL INSERT Statements |
MongoDB insert() Statements |
INSERT INTO users(user_id, age, status) VALUES ("bcd001", 45, "A") |
db.users.insert( {user_id:"bcd001",age:45,status:"A"} ) |
3. update更新
SQL Update Statements |
MongoDB update() Statements |
UPDATE users SET status="C" WHERE age>25 |
db.users.update( { age: { $gt:25 } }, { $set: { status:"C" } }, { multi:true } ) |
UPDATE users SET age=age+3 WHERE status="A" |
db.users.update( { status:"A" } , { $inc: { age:3 } }, { multi:true } ) |
4. delete 删除
SQL Delete Statements |
MongoDB remove() Statements |
DELETE FROM users WHERE status="D" |
db.users.remove( { status:"D" } ) |
DELETE FROM users |
db.users.remove({}) |
版权声明:本文博客原创文章。博客,未经同意,不得转载。
mongodb与SQL对应关系表
标签:
本文系统来源:http://www.cnblogs.com/gcczhongduan/p/4736632.html
内容总结
以上是互联网集市为您收集整理的mongodb与SQL对应关系表全部内容,希望文章能够帮你解决mongodb与SQL对应关系表所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。