组里学mongo,今天花一个多小时稍微看一看基于语句。
以常用的关系型数据和mongodb做比较。
1、连接mongo
mongo --port 10001
mongo: show dbs
mongo: use dbname
mongo: show collections
5、插入数据
rdbms :insert into table (column) values ();
mongo: db.inventory.insert( { "name": "test22", "age": 24, "sex":"man"})
6、查看数据
rdbms: select * from inventory;
mongo: db.inventory.find()
7、 where 查询
rdbms: select * from inventory where name = 'test';
mongo: db.inventory.find({"name":"test"},{"age":1,"sex":1})
8、模糊查询
rdbms: select * from inventory where name like '%test%';
mongo: db.inventory.find({"name":/test/})
9、limit
rdbms: select * from inventory limit 3;
mongo: db.inventory.find().limit(3)
10、or查询
rdbms: select name,age from inventory where sex like '%wo%' or sex like '%ma%';
mongo: db.inventory.find({"$or":[{"sex":/wo/},{"sex":/ma/}]},{"name":true,"age":true})
11、update
rdbms: update inventory set name ='kk' and age = 22 where sex = 'man';
mongo: db.inventory.update({"sex":"man"},{"$set":{"name":"kk","age":22}},false,true)
此处需注意,如果不加false,true,只会更新一条数据,而不是全部更新
12、delete
rdbms: delete from inventory where sex = 'other';
mango: db.inventory.remove({"sex":"other"})