lnsf是数据库,user是其数据集合
//1.进入lnsf2017数据库
use lnsf;
//2.向数据库的user集合中插入一个文档
db.user.insert({username:“sunwukong”,age:18,gender:“male”,face:“handsome”});
//3.查询user集合中的文档
db.user.find();
//4.向数据库的user集合中插入一个文档
db.user.insert({username:“zhubajie”,age:28,gender:“male”,face:“ugly”});
//5.查询数据库user集合中的文档
db.user.find();
//6.统计数据库user集合中的文档数量
db.user.count();
//7.查询数据库user集合中username为sunwukong的文档
db.user.find({username:“sunwukong”});
//8.向数据库user集合中的username为sunwukong的文档,添加一个address属性,属性值为huaguoshan
db.user.update({username:“sunwukong”},{$set:{address:“huaguoshan”}});
//9.使用{username:“tangseng”} 替换 username 为 zhubajie的文档
db.user.update({username:“zhubajie”},{$set:{username:“tangseng”}});
//10.删除username为sunwukong的文档的address属性
db.user.update({username:“sunwukong”},{$unset:{address:“huaguoshan”}});
//11.向username为sunwukong的文档中,添加一个hobby:{cities:[“beijing”,“shanghai”,“shenzhen”] , movies:[“sanguo”,“hero”]}
db.user.update({username:“sunwukong”},{$set:{hobby:{cities:[“beijing”,“shanghai”,“shenzhen”] , movies:[“sanguo”,“hero”]}}})
//12.向username为tangseng的文档中,添加一个hobby:{movies:[“A Chinese Odyssey”,“King of comedy”]}
db.user.update({username:“tangseng”},{$set:{hobby:{movies:[“A Chinese Odyssey”,“King of comedy”]}}});
//13.查询喜欢电影hero的文档
db.user.find({‘hobby.movies’:{
KaTeX parse error: Expected '}', got 'EOF' at end of input: elemMatch:{
eq:‘hero’}}});
db.user.find({‘hobby.movies’:{
KaTeX parse error: Expected 'EOF', got '}' at position 13: all:['hero']}̲}); db.user.fin…in:[‘hero’]}});
db.user.find({$or:[{‘hobby.m