快速入门mongodb

version: "3"
services:
  mysql:
    image: mysql:5.7
    volumes:
      - dai_mysql:/var/lib/mysql
    restart: always
    ports:
      - "3306:3306"
    environment:
      MYSQL_ROOT_PASSWORD: mysql
      MYSQL_USER: root
      MYSQL_PASSWORD: mysql


  redis:
    restart: always
    image: redis:latest
    ports:
      - "6379:6379"
    command: redis-server
    volumes:
      - dai_redis:/data


  mongo:
    restart: always
    image: mongo:latest
    ports:
      - "27017:27017"
    volumes:
      - dai_mongo:/data
volumes:
  dai_mysql:
  dai_redis:
  dai_mongo:

user = [
    {
     "name":"周圣","age":29,"gender": '男',
     "address":"浙江省","work":"软件工程师","hobby":["乒乓球","旅游","读书"]
    },


    {
        "name": "周晓", "age": 19, "gender": '女',
        "address": "安徽省", "work": "UI设计师", "hobby": ["睡懒觉", "唱歌", "游泳"]
    },


    {
        "name": "赵小会", "age": 23, "gender": '男',
         "address": "河南省", "work": "C++开始工程师", "hobby": ["足球", "篮球", "游泳"]
    },
    {
        "name": "张博", "age": 27, "gender": '男',
         "address": "河南省", "work": "C#工程师", "hobby": ["游戏", "直播"]
    },
    {
        "name": "凡凡", "age": 27, "gender": '男',
        "address": "辽宁省", "work": "产品经理", "hobby": ["游戏", "泡妹子"]
    },
    {
        "name": "磊磊", "age": 31, "gender": '男',
        "address": "河北省", "work": "iOS开发", "hobby": ["看书", "泡妹子"]
    },
]

1.在内存中创建 mymongodb数据库
use mymongodb


2.在mymongodb创建集合 users并插入一条数据 
db.users.insert({"name":"周圣","age":29,"gender": '男',"address":"浙江省","work":"软件工程师","hobby":["乒乓球","旅游","读书"]})


3.查看数据库列表
show dbs;


4.查看当前数据的集合(表)
show collections


5.查看users集合的文档
db.users.find().pretty();


6.批量插入用户信息
db.users.insertMany([
{
        "name": "周晓", "age": 19, "gender": '女',
        "address": "安徽省", "work": "UI设计师", "hobby": ["睡懒觉", "唱歌", "游泳"]
    },


    {
        "name": "赵小会", "age": 23, "gender": '男',
         "address": "河南省", "work": "C++开始工程师", "hobby": ["足球", "篮球", "游泳"]
    },
    {
        "name": "张博", "age": 27, "gender": '男',
         "address": "河南省", "work": "C#工程师", "hobby": ["游戏", "直播"]
    },
    {
        "name": "凡凡", "age": 27, "gender": '男',
        "address": "辽宁省", "work": "产品经理", "hobby": ["游戏", "泡妹子"]
    },
    {
        "name": "磊磊", "age": 31, "gender": '男',
        "address": "河北省", "work": "iOS开发", "hobby": ["看书", "泡妹子"]
    }
])


=============比较运算符=========
1.查询age=27的用户信息
db.users.find({"age":27});
2.查询age=27的第一个用户信息
db.users.findOne({"age":27});
3.查询age!=27的用户信息
db.users.find({"age":{$ne:27}}).pretty()
4.查询age>27的用户信息
db.users.find({"age":{$gt:27}}).pretty()
4.查询age>=27的用户信息
db.users.find({"age":{$gte:27}}).pretty()
5.查询age<=27的用户信息
db.users.find({"age":{$lte:27}}).pretty()


=====逻辑查询 and or====
1.查询年纪小于27岁且为女生的用户信息
db.users.find({$and:[{"age":{$lt:27}},{"gender":"女"}]}).pretty()
简写
db.users.find({"age":{$lt:27},"gender":"女"}).pretty()
2.查询年纪大于27岁或者为河北省的用户信息
db.users.find({$or:[{"age":{$gt:27}},{"address":"河北省"}]})
3.查询年龄为19和29的用户信息
db.users.find({"age":{$in:[19,29]}}).pretty()
4.查询年龄不是19,27,29的用户信息
db.users.find({"age":{$nin:[19,27,29]}}).pretty()
5.查询用户名以 '周'开头
db.users.find({"name":{$regex:"^周"}}).pretty()
6.分页:每页2条记录，查询第二页用户信息
db.users.find().skip(2).limit(2).pretty()
7.查询年龄小于27岁用户的名字
db.users.find({"age":{$lt:27}},{"_id":0,"name":1})
8.查询用户的名字和年龄，同时按照升序排序
db.users.find({},{"name":1,"age":1}).sort({"age":1})
9.统计男生的个数
db.users.find({"gender":"男"}).count()
10.将周圣的年纪改成28岁
db.users.update({"name":"周圣"},{$set:{"age":28}})
11.将赵小会这个用户删除掉
db.users.remove({"name":"赵小会"})