mongoDB常用语句

罗列一些常用增删改查语句，及对应的mysql的sql语句

1.查所有

db.c1.find()
use db；select * from c1;

2.条件查询

db.things.find({name:"mongo"})
use db；select * from things;

 

3.模糊查询

db.products.find( { sku: { $regex: /^789/ } } )
SELECT * FROM products WHERE sku like "789%";

db.products.find( { sku: { $regex: /789$/ } } )
SELECT * FROM products WHERE sku like "%789";

4.排序

升序
db.products.find({}).sort({ time:1 })
降序
db.products.find({}).limit(50).sort({ time:-1 })

4.筛选

db.products.find().limit(3);
SELECT * FROM products limit 3;

5.更新

db.products.update({name:"mongo"},{$set:{name:"mongo_new"}});
update products set name='mongo_new' where name='mongo';

6.删除

db.products.remove({name:"mongo_new"});
delete from products where name='mongo_new';

7.插入

db.products.insert({name:"mongo_new",pwd:"123456"});
insert into products(name,pwd) values('mongo_new','123456');