use my_test
db.users.insert({
username:"sunwukong"
});
db.users.find();
db.users.insert({
username:"zhubajie"
});
db.users.find();
db.users.find().count();
db.users.find({username:"sunwukong"});
db.users.update({username:"sunwukong"},{$set:{address:"huaguoshan"}});
db.users.replaceOne({username:"zhubajie"},{username:"tangseng"});
db.users.update({username:"sunwukong"},{$unset:{address:1}});
db.users.update({username:"sunwukong"},{$set:{hobby:{cities:["beijing","shanghai","shenzhen"] , movies:["sanguo","hero"]}}});
db.users.find();
db.users.update({username:"tangseng"},{$set:{hobby:{movies:["A Chinese Odyssey","King of comedy"]}}})
db.users.find({'hobby.movies':"hero"});
db.users.update({username:"tangseng"},{$push:{"hobby.movies":"Interstellar"}});
db.users.update({username:"tangseng"},{$addToSet:{"hobby.movies":"Interstellar"}});
db.users.find();
db.users.remove({"hobby.cities":"beijing"});
db.users.remove({});
db.users.drop();
show dbs;
for(var i=1 ; i<=20000 ; i++){
db.numbers.insert({num:i});
}
db.numbers.find()
db.numbers.remove({});
var arr = [];
for(var i=1 ; i<=20000 ; i++){
arr.push({num:i});
}
db.numbers.insert(arr);
db.numbers.find({num:500})
db.numbers.find({num:{$gt:500}});
db.numbers.find({num:{$eq:500}});
db.numbers.find({num:{$lt:30}});
db.numbers.find({num:{$gt:40 , $lt:50}});
db.numbers.find({num:{$gt:19996}});
db.numbers.find({num:{$lte:10}});
db.numbers.find().limit(10);
db.numbers.find();
db.numbers.find().skip(10).limit(10);
db.numbers.find().skip(20).limit(10);
db.numbers.find().limit(10).skip(10);
db.dept.find()
db.emp.find()
db.emp.find({sal:{$lt:2000}});
db.emp.find({sal:{$lt:2000 , $gt:1000}});
db.emp.find({$or:[{sal:{$lt:1000}} , {sal:{$gt:2500}}]});
var depno = db.dept.findOne({dname:"财务部"}).deptno;
db.emp.find({depno:depno});
var depno = db.dept.findOne({dname:"销售部"}).deptno;
db.emp.find({depno:depno});
db.emp.find({mgr:7698})
db.emp.updateMany({sal:{$lte:1000}} , {$inc:{sal:400}});
db.emp.find()