mongodb与SQL相应关系表
1. select查询
find批量查询。
findOne是查询一条记录。
find有两个參数： 第一个查询条件， 第二个查询返回的字段。
|
SQL SELECT Statements |
MongoDB find() Statements |
|
SELECT * FROM users |
db.users.find() |
|
SELECT id, user_id, status FROM users |
db.users.find( { }, } ) |
|
SELECT user_id,status FROM users |
db.users.find( { }, } ) |
|
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" }, } ) |
|
SELECT * FROM users WHERE status!="A" |
db.users.find( { status: {$ne:"A" ) |
|
SELECT * FROM users WHERE status="A"
|
db.users.find( { status:"A", } ) |
|
SELECT * FROM users WHERE status="A"
|
db.users.find( { $or: [ {status:"A" } ] } ) |
|
SELECT * FROM users
|
db.users.find( } } ) |
|
SELECT * FROM users
|
db.users.find( } } ) |
|
SELECT * FROM users
|
db.users.find( } } ) |
|
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" |
|
SELECT * FROM users WHERE status="A" ORDER BY user_id DESC |
db.users.find( {status:"A" |
|
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 |
|
SELECT COUNT(*) FROM users
|
or
|
|
SELECT DISTINCT(status) FROM users |
db.users.distinct("status" ) |
|
SELECT * FROM users
|
db.users.findOne() or ) |
|
SELECT * FROM users
|
) |
|
EXPLAIN SELECT * FROM users WHERE status="A" |
db.users.find( {status:"A" |
2. insert插入
|
SQL INSERT Statements |
MongoDB insert() Statements |
|
INSERT INTO users(user_id, age, status) VALUES ("bcd001", , "A") |
db.users.insert( ,status:"A"} ) |
3. update更新
|
SQL Update Statements |
MongoDB update() Statements |
|
UPDATE users SET status="C"
|
db.users.update( { age: { { $set: { { multi:true } ) |
|
UPDATE users
WHERE status="A" |
db.users.update( { status:"A" } , { $inc: { { multi:true } ) |
4. delete 删除
|
SQL Delete Statements |
MongoDB remove() Statements |
|
DELETE FROM users WHERE status="D" |
db.users.remove( { |
|
DELETE FROM users |
db.users.remove({}) |
最新文章
- HTML: vertical algin Big/small div in same row (bootstrap)
- [CareerCup] 13.7 Node Pointer 节点指针
- js中数组以及for循环的使用
- phpStudy启动失败时的解决方法
- freebsd上安装nginx+php记录
- jquery 取值赋值
- SRM588
- poj2826（线段相交）
- UVA11107 Life Forms
- 使用Mongo进行分页
- python+selenium测试
- 【APP测试（Android）】－－安全测试
- [hgoi#2019/2/16t3]psolve
- 【BARTS计划】【Share_Week1】社交产品思考
- Exp1 逆向与bof基础
- luoguP5074 Eat the Trees
- 20155302 2016-2017-2 《Java程序设计》第3周学习总结
- 使用SpringMVC解决Ajax跨域问题
- xdebug的安装测试
- Struts2_HelloWorld_3