#切换机器用户
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({})