use admin switched to db admin test1:PRIMARY> rs.status() { "set" : "test1", "date" : ISODate ("2023-10-23T02:30:54.919Z"), "lastDurableWallTime" : ISODate("2023-10-23T02:30:54.919Z ("2023-10-23T02:30:24.912Z"), "wMajorityWriteAvailabilityDate" : ISODate("2023-10-23T02 ("2023-10-23T02:30:54Z"), "optimeDurableDate" : ISODate("2023-10-23T02:30:54Z ("2023-10-23T02:30:54Z"), "optimeDurableDate" : ISODate("2023-10-23T02:30:54Z
示例 假设现在接近2019年1月末,集合bakesales包含按项目分类的销售信息: db.bakesales.insertMany( [ { date: new ISODate("2018-12 -01"), item: "Cake - Chocolate", quantity: 2, amount: new NumberDecimal("60") }, { date: new ISODate -02"), item: "Cake - Peanut Butter", quantity: 5, amount: new NumberDecimal("90") }, { date: new ISODate , item: "Cookies - Chocolate Chip", quantity: 20, amount: new NumberDecimal("80") }, { date: new ISODate 执行初始运行 对于初始运行,你可以传入一个日期new ISODate("1970-01-01"): updateMonthlySales(new ISODate("1970-01-01")); 初始运行后
("2020-04-11T06:55:43.562Z"), "lastDurableWallTime" : ISODate("2020-04-11T06:55:43.562Z ("2020-04-11T06:55:23.013Z"), "wMajorityWriteAvailabilityDate" : ISODate("2020-04-11T06 ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z "lastHeartbeatRecv" : ISODate("2020-04-11T06:55:42.499Z"), "pingMs" : NumberLong ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z
node3 192.168.56.199:27017 SECONDARY test12:PRIMARY> rs.status() { "set" : "test12", "date" : ISODate ("2021-12-16T13:45:18.626Z"), "lastDurableWallTime" : ISODate("2021-12-16T13:45:18.626Z") }, ("2021-12-14T15:24:57.321Z"), "wMajorityWriteAvailabilityDate" : ISODate("2021-12-14T15:24:58.285Z " : ISODate("2021-12-16T13:45:27.463Z"), "lastHeartbeatRecv" : ISODate("2021-12-16T13:45:26.387Z " : ISODate("2021-12-16T13:45:28.253Z"), "lastHeartbeatRecv" : ISODate("2021-12-16T13:45:27.555Z
"lastHeartbeat" : ISODate("2018-02-05T11:08:23.635Z"), "lastHeartbeatRecv" : ISODate("2018 "lastHeartbeat" : ISODate("2018-02-05T11:08:23.674Z"), "lastHeartbeatRecv" : ISODate("2018 "lastHeartbeat" : ISODate("2018-02-05T11:53:10.139Z"), "lastHeartbeatRecv" : ISODate("2018 "lastHeartbeat" : ISODate("2018-02-05T12:35:33.244Z"), "lastHeartbeatRecv" : ISODate("2018 "lastHeartbeat" : ISODate("2018-02-05T12:42:56.392Z"), "lastHeartbeatRecv" : ISODate("2018
("2020-04-11T06:55:43.562Z"), "lastDurableWallTime" : ISODate("2020-04-11T06:55:43.562Z ("2020-04-11T06:55:23.013Z"), "wMajorityWriteAvailabilityDate" : ISODate("2020-04-11T06 ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z "lastHeartbeatRecv" : ISODate("2020-04-11T06:55:42.499Z"), "pingMs" : NumberLong ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z
userId':{$in:[1,2,3,4,5,6,7,8]}}) 查询指定时间区间 2019-03-26整天的登录信息 db.UserLoginLog.find({'loginTime':{$gt:ISODate ('2019-03-26T00:00:00Z'),$lte:ISODate( '2019-03-26T23:59:59Z' )}}) 排序查询 db.UserLoginLog.find({}).sort ('2019-03-26T00:00:00Z'),$lte:ISODate( '2019-03-26T23:59:59Z' )},'isValid':1}}, {$group:{_id:"$userId "}} ]) 查询指定时间段内,userId总数 db.UserLoginLog.aggregate([ {$match:{'loginTime' : {$gt:ISODate('2019-03 -26T00:00:00Z'),$lte:ISODate( '2019-03-26T23:59:59Z' )},'isValid':1}}, {$group:{_id:"$userId"}},
("2016-08-30T05:41:06Z"), "lastHeartbeat" : ISODate("2016-08-30T05:41:14.030Z ("2016-08-30T05:41:06Z"), "lastHeartbeat" : ISODate("2016-08-30T05:41:14.030Z ("1970-01-01T00:00:00Z"), "lastHeartbeat" : ISODate("2016-08-30T05:45:38.378Z ("2016-08-30T05:44:05Z"), "lastHeartbeat" : ISODate("2016-08-30T05:45:38.356Z ("2016-08-30T05:44:05Z"), "lastHeartbeat" : ISODate("2016-08-30T05:47:24.819Z
("2020-04-11T07:23:16.099Z"), "lastDurableWallTime" : ISODate("2020-04-11T07:23:16.099Z ("2020-04-11T07:23:06.098Z"), "wMajorityWriteAvailabilityDate" : ISODate("2020-04-11T07 ("2020-04-11T07:23:16Z"), "optimeDurableDate" : ISODate("2020-04-11T07:23:16Z "lastHeartbeatRecv" : ISODate("2020-04-11T07:23:19.161Z"), "pingMs" : NumberLong ("2020-04-11T07:23:20.049Z"), "lastHeartbeatRecv" : ISODate("2020-04-11T07:23
在界面中加入下面的JSON数据 { marketno:'2', stockno:'600055', stock_name:'万东医疗', issue_date:ISODate ('1997-04-18'), issue_price:8.5400, list_date:ISODate('1997-05-19'), list_market:'上海证券交易所 ('2016-06-17'), updated_by:'system', updated_date:ISODate('2016-06-17'), assortment_id:'1 ' } { marketno:'2', stockno:'600059', stock_name:'古越龙山', issue_date:ISODate('1997-04- ('2016-06-17'), updated_by:'system', updated_date:ISODate('2016-06-17'), assortment_id:'1
rs.status() 查看返回值: { "set" : "test", "date" : ISODate("2016-09-22T08:08:36.607Z"), "myState" : 1, " : ISODate("2016-09-22T08:08:32.078Z"), "pingMs" : NumberLong(0), "syncingTo" : "10.55.160.91: " : ISODate("2016-09-22T08:08:32.078Z"), "pingMs" : NumberLong(0), "syncingTo" : "10.55.160.91: " : ISODate("2016-09-22T09:28:52.095Z"), "pingMs" : NumberLong(0), "syncingTo" : "10.55.160.93: " : ISODate("2016-09-22T09:28:52.095Z"), "pingMs" : NumberLong(0), "syncingTo" : "10.55.160.93:
db.mydoc.insertMany([ { item:"canvas", qty:120, size:{ h:28, w:35.5, uom:"cm" }, status:"A", createDate:ISODate type:"paper"}, {tag:"red", type:"electron"} ], size:{ h:14, w:21, uom:"cm" }, status:"A", createDate:ISODate type:"paper"}, {tag:"green", type:"electron"}], size:{ h:8.5, w:11, uom:"in" }, status:"P", createDate:ISODate "paper"}, {tag:"green", type:"electron"}], size:{ h:22.85, w:30, uom:"cm" }, status:"D", createDate:ISODate ("2016-02-11T20:20:13Z") }, { item:"sketchbook", qty:80, status:"A", createDate:ISODate("2016-02-12T20
] } ) 返回值 { "ok" : 1 } 5.8、查询状态 rs.status() 返回值 { "set" : "shard2", "date" : ISODate ("2020-04-11T07:18:38.648Z"), "lastDurableWallTime" : ISODate("2020-04-11T07:18:38.648Z ("2020-04-11T07:18:38.537Z"), "lastHeartbeatRecv" : ISODate("2020-04-11T07:18 ("2020-04-11T07:18:28Z"), "optimeDurableDate" : ISODate("2020-04-11T07:18:28Z "lastHeartbeatRecv" : ISODate("2020-04-11T07:18:38.802Z"), "pingMs" : NumberLong
", "Date" : ISODate("2015-02-11T03:12:03.061Z") } 插入 --插入文档对象 > db.blog.insert(post) ", "Date" : ISODate("2015-02-11T03:17:07.219Z") } > db.blog.insert(post) 读取 --读取集合里一个文档 ", "Date" : ISODate("2015-02-11T03:12:03.061Z") } --读取限定文档数 > db.blog.find().limit(100) ", "Date" : ISODate("2015-02-11T03:12:03.061Z") } { "_id" : ObjectId("54dac9b8c956bbcbefa8151d"), " ", "Date" : ISODate("2015-02-11T03:17:07.219Z") } --读取所有文档数 > db.blog.find() { "_id" : ObjectId
("2022-11-22T07:52:46.945Z"), "lastDurableWallTime" : ISODate("2022-11-22T07:52:46.945Z ("2022-11-22T07:52:46Z"), "optimeDurableDate" : ISODate("2022-11-22T07:52:46Z" "lastDurableWallTime" : ISODate("2022-11-22T07:52:46.945Z"), "lastHeartbeat" : ISODate("2022-11-22T07:52:52.764Z"), "lastHeartbeatRecv" : ISODate("2022-11-22T07 ISODate("2022-11-22T07:52:52.764Z"), "lastHeartbeatRecv" : ISODate("2022-11-22T07
}" type="time"/> 23:59:59 <fmt:formatDate value="${<em>isoDate</em>}" type="date" dateStyle="default"/> 2004 -5-31 <fmt:formatDate value="${<em>isoDate</em>}" type="date" dateStyle="short"/> 04-5-31 <fmt:formatDate value ="${<em>isoDate</em>}" type="date" dateStyle="medium"/> 2004-5-31 <fmt:formatDate value="${<em>isoDate</em>}" type="date value="${isoDate}" type="time" timeStyle="short"/> 下午11:59 <fmt:formatDate value="${<em>isoDate</em>}" type= "time" timeStyle="medium"/> 23:59:59 <fmt:formatDate value="${<em>isoDate</em>}" type="time" timeStyle="long"
("2020-04-11T06:55:43.562Z"), "lastDurableWallTime" : ISODate("2020-04-11T06:55:43.562Z ("2020-04-11T06:55:23.013Z"), "wMajorityWriteAvailabilityDate" : ISODate("2020-04-11T06 ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z "lastHeartbeatRecv" : ISODate("2020-04-11T06:55:42.499Z"), "pingMs" : NumberLong ("2020-04-11T06:55:31Z"), "optimeDurableDate" : ISODate("2020-04-11T06:55:31Z
"ts" : Timestamp(1639190792, 1), "h" : NumberLong(0), "v" : 2, "op" : "n", "ns" : "", "wall" : ISODate ); { "ts" : Timestamp(1639190792, 1), "h" : NumberLong(0), "v" : 2, "op" : "n", "ns" : "", "wall" : ISODate $cmd", "ui" : UUID("c3c70f0e-028e-4db8-85b4-79e8b65eccc9"), "wall" : ISODate("2021-12-11T02:46:43.802Z $cmd", "ui" : UUID("b2fb5908-b21b-4ed5-9f2d-218396875b19"), "wall" : ISODate("2021-12-11T02:46:43.806Z $cmd", "ui" : UUID("4a7fa891-c1a9-49a6-abc4-d94693030358"), "wall" : ISODate("2021-12-11T02:46:43.810Z
.”, “Date” : ISODate(“2015-02-11T03:12:03.061Z”) } 插入 –插入文档对象 > db.blog.insert(post) > “title” : “Licz Blog Post”, “Content” : “Here is my blog Post.”, “Date” : ISODate “title” : “My Blog Post”, “Content” : “Here is my blog Post.”, “Date” : ISODate 54dac88dc956bbcbefa8151c”), “title” : “My Blog Post”, “Content” : “Here is my blog Post.”, “Date” : ISODate 54dac88dc956bbcbefa8151c”), “title” : “My Blog Post”, “Content” : “Here is my blog Post.”, “Date” : ISODate
"lastHeartbeat" : ISODate("2017-12-04T07:42:08.637Z"), "lastHeartbeatRecv" : ISODate("2017 "lastHeartbeat" : ISODate("2017-12-04T07:42:08.637Z"), "lastHeartbeatRecv" : ISODate("2017 ("2017-12-04T07:51:53.597Z"), "lastHeartbeatRecv" : ISODate("2017-12-04T07:51:51.243Z"), "lastHeartbeat" : ISODate("2017-12-04T08:04:30.527Z"), "lastHeartbeatRecv" : ISODate("2017 "lastHeartbeat" : ISODate("2017-12-04T08:07:37.488Z"), "lastHeartbeatRecv" : ISODate("2017