//1.创建一个it666的数据库
use it666;
db
//2.向数据库的college集中中加入6个文档(HTML5,java,区块链,python,大数据,(PHP,“世界上最好的语言”))
db.colleges.insert([
{name:'HTML5'},
{name:"java"},
{name:'区块链'},
{name:'python'},
{name:'K12'},
{name:'PHP',intro:'世界上最好的语言'}
])
//3.查询colleges集合里面所有的文档
db.colleges.find()
//4.向数据库里面的colleges里面再添加一个文档
db.colleges.insert({name:'go'})
db.colleges.find()
//5.统计数据库中colleges里面文档的数量
db.colleges.find().count()
db.colleges.find().length()
//6.查询数据库colleges里面name为HTML5的文档
db.colleges.find({name:'HTML5'})
//7.向数据库colleges集合中的name为HTML5的文档添加一个intro属性,属性值为“打通全栈的任督二脉”
db.colleges.update({name:'HTML5'},{$set:{intro:'打通全栈的任督二脉'}})
db.colleges.find()
//8.使用name值为“K12”来替换name值为“大数据”
db.colleges.update({name:'K12'},{$set:{name:'大数据'}})
db.colleges.find()
//9.删除name为PHP的文档的intro属性
db.colleges.update({name:'PHP'},{$unset:{intro:1}})
db.colleges.find()
//10.向name为HTML5的文档中再加入一个classes:{base:["H5+C3","jQuery","javascript"], core:['三大框架','node.js']}
db.colleges.update({name:'HTML5'},
{$set:{classes:{base:["H5+C3","jQuery","javascript","abc"],
core:['三大框架','node.js']
}
}
})
db.colleges.find()
//11.查询核心课程为三个框架的文档
db.colleges.find({'classes.core':'三大框架'})
//12.向HTML5和核心课程里面添加一个“微信小程序”
db.colleges.update({name:'HTML5'},{$push:{'classes.core':'微信小程序'}})
db.colleges.update({name:'HTML5'},{$addToSet:{'classes.core':'公众号开发'}})
db.colleges.find()
//13.删除HTML5里面基础课程为“jquery”的文档
db.colleges.update({name:"HTML5"},{$pop:{"classes.base":1}});
db.colleges.find()
//14.删除colleges
db.colleges.remove()
db.colleges.drop()