//1.进入my_test数据库 use enjoy
//2.向数据库的user集合中插入一个usename为deer的文档
db.user.insert({username:"deer"})
//3.查询user集合中的文档 db.user.find()
//4.向数据库的user集合中插入一个usename为james的文档
db.user.insert({username:"james"})
//5.查询数据库user集合中的文档
db.user.find()
//6.统计数据库user集合中的文档数量 db.user.find().size()
//7.查询数据库user集合中username为deer的文档 db.user.find({username:"deer"})
//8.向数据库user集合中的username为deer的文档，添加一个address属性，属性值为changsha db.user.update({username:"deer"},{$push:{address:"changsha"}})
db.user.update({username:"peter"},{$set:{adress:"长沙"}})
//9.使用{username:"peter"} 替换 username 为 james的文档 db.user.update({username:"james"},{$set:{username:"peter"}})
db.user.find()
//10.删除username为deer的文档的address属性 (multi:true 默认删除含有全部的,默认false) db.user.update({username:"deer"},{$unset:{address:""}},{multi:true})
db.user.update({username:"deer"},{$unset:{address:""}})
//db.user.update({"_id":new ObjectId("603f291c8d6bdf2a0d93fbb1")},{$set:{"address":"shanghai"}})
//11.向username为deer的文档中，添加一个hobby:{cities:["beijing","shanghai","shenzhen"] , movies:["djr","huluwa"]} db.user.update({username:"deer"},{$push:{hobby:{cities:["beijing","shanghai","shenzhen"] , movies:["djr","huluwa"]}}})
db.user.find({username:"deer"})
db.user.update({username:"deer"},{$set:{hobby:{cities:["beijing","shanghai","shenzhen"] , movies:["djr","huluwa"]}}})
//12.向username为peter的文档中，添加一个hobby:{movies:["king of china","yiluxiangxi"]} //这里做添加的时候要注意set和push的区别 都可以做到添加数据的效果,但是push是往数组中添加数据 db.user.update({username:"peter"},{set:{hobby:{movies:["king of china","yiluxiangxi"]}}}) db.user.find({username:"peter"}) db.user.update({username:"peter"},{unset:{"hobby":1}},{multi:true})
//13.查询喜欢电影djr的文档 db.user.find({"hobby.movies":"djr"})
//13.1查询 喜欢djr 和huluwa的文档 db.user.find({$and:[{"hobby.movies":"djr"},{"hobby.movies":"huluwa"}]})
//13.2查询 喜欢djr 或hulw的文档 db.user.find({$or:[{"hobby.movies":"djr"},{"hobby.movies":"huluwa"}]})
//14.向peter中添加一个新的电影jpm db.user.find({username:"peter"}) db.user.update({username:"peter"},{set:{hobby:{"movies":"jpm2"}}}) db.user.update({username:"peter"},{push:{"hobby.movies":"jpm2"}}) db.user.update({username:"peter"},{$addToSet:{"hobby.movies":"jpm"}})
db.user.update({username:"peter"},{$unset:{"hobby":1}},{multi:true})
//15.删除喜欢beijing的用户 db.user.remove({"hobby.cities":"beijing"})
db.user.insert({username:"deer"}) db.user.insert({username:"deer"}) db.user.find({username:"deer4"}).size() //删除是删除多条 db.user.remove({username:"deer"})
//按条件修改的时候默认是修改一条,如果加了{multi:true}则是修改所有符合条件的
db.user.update({username:"deer"},{$set:{username:"deer3"}},{multi:true})
db.user.update({username:"deer3"},{$set:{username:"deer4"}})
//16.删除user集合 db.user.drop() db.user.find()
//17.向persons中插入20000条数据 //该种方式很慢 for(var i =1;i<=1000;i++){ var sz = new NumberInt(i) db.persons.insert({num:sz}) } db.persons.find().size()
//18.查询persons中num为500的文档 db.persons.find({num:500})
//19.查询persons中num大于500的文档 db.persons.find({num:{$gt:500}}).size()
//20.查询persons中num小于30的文档 db.persons.find({num:{$lt:30}})
//21.查询persons中num大于40小于50的文档 db.persons.find({and:[{num:{gt:40}},{num:{$lt:50}}]})
//22.查询persons中num大于199的文档 db.persons.find({num:{$gt:199}})
//23.查看persons集合中的前10条数据 db.persons.find().limit(10) db.user.find({username:"peter"}) //24.查看persons集合中的第11条到20条数据 db.persons.find().limit(10).skip(10)
//25.查看persons集合中的第21条到30条数据 db.persons.find().limit(10).skip(20)
