mongdb之集合基本操作

来源:互联网 发布:淘宝加入购物车看不到 编辑:程序博客网 时间:2024/03/29 17:17
> use ColTest(创建数据库若该数据库不存在,若该数据库存在,则使用该数据库)

switched to db ColTest


> show collections(展示该数据库下所有的集合)


> db.createCollection("test");(创建名为test的集合)

{ "ok" : 1 }


> show collections

test


> db.test.insert({"id":78,"name":"jane","sex","woman"});()


> db.test.insert({"id":78,"name":"jane","sex":"woman"});(向集合中插入数据)

WriteResult({ "nInserted" : 1 })


> db.test.find();(查询test集合下面的所有数据)


{ "_id" : ObjectId("597741804c94dc71045af105"), "id" : 78, "name" : "jane", "sex" : "woman" }


> db.test.insert({"id":72,"name":"janlu","sex":"woman"});
WriteResult({ "nInserted" : 1 })
> db.test.insert({"id":97,"name":"ludy","sex","man"});
2017-07-25T21:04:01.169+0800 E QUERY    [thread1] SyntaxError: missing : after property id @(shell):1:43

> db.test.find();


{ "_id" : ObjectId("597741804c94dc71045af105"), "id" : 78, "name" : "jane", "sex" : "woman" }

{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 72, "name" : "janlu", "sex" : "woman" }


> db.test.insert({"id":97,"name":"ludy","sex":"man"});

WriteResult({ "nInserted" : 1 })


> db.test.find();


{ "_id" : ObjectId("597741804c94dc71045af105"), "id" : 78, "name" : "jane", "sex" : "woman" }
{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 72, "name" : "janlu", "sex" : "woman" }

{ "_id" : ObjectId("597741dd4c94dc71045af107"), "id" : 97, "name" : "ludy", "sex" : "man" }


> db.test.find({"id":78});(带有条件的查询)

{ "_id" : ObjectId("597741804c94dc71045af105"), "id" : 78, "name" : "jane", "sex" : "woman" }


> db.test.remove({"id":78});(带有条件的删除)

WriteResult({ "nRemoved" : 1 })


> db.test.find();
{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 72, "name" : "janlu", "sex" : "woman" }

{ "_id" : ObjectId("597741dd4c94dc71045af107"), "id" : 97, "name" : "ludy", "sex" : "man" }


> db.test.find().limit(1);(从集合中抽取多少条数据)

{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 72, "name" : "janlu", "sex" : "woman" }


> db.test.find();
{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 72, "name" : "janlu", "sex" : "woman" }

{ "_id" : ObjectId("597741dd4c94dc71045af107"), "id" : 97, "name" : "ludy", "sex" : "man" }


> db.test.update({id:72},{id:90,sex:"man"})(更新数据)

WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })


> db.test.find();
{ "_id" : ObjectId("597741ad4c94dc71045af106"), "id" : 90, "sex" : "man" }

{ "_id" : ObjectId("597741dd4c94dc71045af107"), "id" : 97, "name" : "ludy", "sex" : "man" }


基本操作,便于记住(哈哈)


原创粉丝点击