Mongo 常用命令

#切换机器用户
sudo -i
#进入到容器
docker exec -it docker_name bash 
#连接Mongo数据库
mongo 127.0.0.1:27017/demo -uroot -pmy_pw
#查询集合
show collections;
#新建集合
db.createCollection("dts_sink")
#查询表内容(id>=100)
db.dts_source.find({likes : {$gte: 1}});
#查询表内容ObjectId
db.test_col9.findOne({_id:ObjectId("6523c46d9a3e8acb53367b6a")});
#插入数据
db.dts_test_lj.insertOne({
    "name":"韩梅梅",
    "NumberDecimal":NumberDecimal("13294.98765"),
    "array":["羽毛球","乒乓球","篮球","台球"],
    "Object":{"name":"Mango","price":1000},
    "Booble":true,
    "Null": null,
    "timetamp":Timestamp(1676969776,1),
    "ISOdate":ISODate("2019-01-05T15:28:33.705+08:00"),
    "double":1.77769313486232,
    "long":NumberLong(-922337203685477580),
    "Int":NumberInt(123302327810906),
    "objectID":ObjectId("5f2a22f7aa56fc2fc978b159"),
    "address":"北京市香坊区四纬二组哈哈街道",
    "regex":RegExp("^Guru91$"),
    "Bindata":HexData(1,"00112233445566778899aabbccddeeff"),
    "Javascript":function(){alert("14")},
    "id":NumberInt(18),
    javascriptwithscope_code_info: "function() { return this.name; }",
    javascriptwithscope_scope_info: { name: "John" },
    undefined_info: undefined,
    Symbol_info:BSONSymbol("unique"),
    reference: {
      $ref: "dts_sink",
      $id: ObjectId("655c1dad27f76508f50fe0bc")
}
    })
#更新数据
db.test_col9.updateOne({_id: new ObjectId("651fac219a3e8acb533678a8")}, {"$set": {string_array_field: ["rex1", "rex2","28号变更"]}})
#删除数据
db.test_col9.deleteOne({_id: new ObjectId("651fac219a3e8acb533678a8")})
#查看版本
mongo --version
#清除表内容
demo.dts_sink.remove({})