appcanLiYunLong的博客

db.sku.aggregate([ { $group:{ _id:'$goods_id', sku:{$push:'$$CURRENT'} } }, { $project:{ _id:1, sku:{ $slice:['$sku',2] } } }])

– UPDATE user set shop_ids = json_set(shop_ids,’[0]′,221)WHEREJSONOVERLAPS(shopids−>′[0]',221) WHERE JSON_OVERLAPS(shop_ids->'[0]′,221)WHEREJSONO​VERLAPS(shopi​ds−>′[]’,’[231]’)– SELECT * FROM user WHERE JSON_OVERLAPS(shop_ids->’[∗]′,′[231]′)

const Mock = require(‘mockjs’)Mock.Random.extend({phone: function() {const phonePrefixs = [‘132’, ‘135’, ‘189’] // 自己写前缀哈return this.pick(phonePrefixs) + Mock.mock(/\d{8}/) // Number()}})const Action = process.env.VUE_APP_DEFAULT_MODEL + ‘Driver’mo

mysql8 json字段查询小白demo 简洁才是好例子snapshot 是json字段 格式二维数组[{"new": 1, "uid": 350, "add_time": 1582679367, "cart_num": 2, "share_uid": "314", "truePrice": "19.90", "unique_id": 309, "product_id": "2"},{"new": 1, "uid": 350, "add_time": 1582679367, "cart_num":

db.serverStatus().connections;{ "current" : 24, "available" : 838836, "totalCreated" : 25, "active" : 1 }当前连接数 “current” : 523可用连接数 “available” : 19477创建线程数 “totalCreated” : 82727299...

mysqlbinlog -d ajt_shop_wechat --base64-output=decode-rows -v --start-datetime=‘2020-03-10 08:00:00’ --stop-datetime=‘2020-03-11 12:00:00’ binlog.000270 > test.sql

/*********MongoDB重启遇到错误、about to fork child process, waiting until server is ready for connections.forked process: 10117ERROR: child process failed, exited with error number 48To see additional in...