三、MongoDB入门

MongoDB入门

• 1. 数据库操作
• 2.数据操作
• • 2.1 新增
  • 2.2 查询
  • 2.3 修改
  • 2.4 删除

1. 数据库操作

启动、连接

# cd /usr/local/mongoDB/mongodbserver/
# bin/mongod -f conf/mongodb.conf
# bin/mongo

查看数据库列表

# show dbs;

新增数据库
没有就会新增

# use rab

查看文档集合(表)

# show collections

2.数据操作

2.1 新增

db.users.drop();
var user1 = {"username" : "lison","country" : "china","address" : {"aCode" : "411000","add" : "长沙"},"favorites" : {"movies" : ["杀破狼2","战狼","雷神1"],"cites" : ["长沙","深圳","上海"]},"age" : 18,"salary":NumberDecimal("18889.09"),"lenght" :1.79};
var user2 = {"username" : "james","country" : "English","address" : {"aCode" : "311000","add" : "地址"},"favorites" : {"movies" : ["复仇者联盟","战狼","雷神1"],"cites" : ["西安","东京","上海"]},"age" : 24,"salary":NumberDecimal("7889.09"),"lenght" :1.35
};
var user3 ={"username" : "deer","country" : "japan","address" : {"aCode" : "411000","add" : "长沙"},"favorites" : {"movies" : ["肉蒲团","一路向西","倩女幽魂"],"cites" : ["东莞","深圳","东京"]},"age" : 22,"salary":NumberDecimal("6666.66"),"lenght" :1.85
};
var user4 =
{"username" : "mark","country" : "USA","address" : {"aCode" : "411000","add" : "长沙"},"favorites" : {"movies" : ["蜘蛛侠","钢铁侠","蝙蝠侠"],"cites" : ["青岛","东莞","上海"]},"age" : 20,"salary":NumberDecimal("6398.22"),"lenght" :1.77
};var user5 =
{"username" : "peter","country" : "UK","address" : {"aCode" : "411000","add" : "TEST"},"favorites" : {"movies" : ["蜘蛛侠","钢铁侠","蝙蝠侠"],"cites" : ["青岛","东莞","上海"]},"salary":NumberDecimal("1969.88")
};db.users.insert(user1);
db.users.insert(user2);
db.users.insert(user3);
db.users.insert(user4);
db.users.insert(user5);

2.2 查询

查询喜欢的城市包含东莞和东京的user

db.users.find({ "favorites.cites" : { "$all" : [ "东莞" , "东京"]}})

查询国籍为英国或者美国，名字中包含s的user

db.users.find({ "$and" : [ { "username" : { "$regex" : ".*s.*"}} , { "$or" : [ { "country" : "English"} , { "country" : "USA"}]}]})

2.3 修改

lison的年龄修改为6岁

db.users.updateMany({ "username" : "lison"},{ "$set" : { "age" : 6}},true)

喜欢的城市包含东莞的人，给他喜欢的电影加入“小电影2”“小电影3”

db.users.updateMany({ "favorites.cites" : "东莞"}, { "$addToSet" : { "favorites.movies" : { "$each" : [ "小电影2 " , "小电影3"]}}},true)

2.4 删除

删除名字为lison的user

db.users.deleteMany({ "username" : "lison"} )

删除年龄大于8小于25的user

db.users.deleteMany({"$and" : [ {"age" : {"$gt": 8}} , {"age" : {"$lt" : 25}}]})

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！