不知道sql语句怎么写，想要把日志中“id”：“22”写入数据库中
2020-12-12 19:37:03.246, 00E3A2E634FE4137AA97BBE36E691819, upstream - bizType=PROPERTY_REPORT,params={"aliyunPk":"1258103779501748","id":"22","iotId":"AW7cwOrd4F4811299ppn000000","method":"thing.event.property.post","params":{"bianhao":215,"bianhaoa":93},"script":true,"topic":"/sys/a1AjjGsgSiN/262045786596/thing/event/property/post","uniMsgId":"5350892502723309568","version":"1.1"},result=code:200,message:success,topic=/sys/a1AjjGsgSiN/262045786596/thing/model/up_raw,response={"code":200,"data":{},"id":"22","message":"success","method":"thing.event.property.post","version":"1.0"},device={"aliyunCommodityCode":"iothub_senior","deviceKey":"AW7cwOrd4F4811299ppn","deviceSecret":"***","firmwareVersion":"1.2.8","gmtCreate":1607753133000,"gmtModified":1607753844000,"id":1842039920,"instanceId":"iotx-oxssharez200","iotId":"AW7cwOrd4F4811299ppn000000","name":"262045786596","nickname":"hanfengg43","productKey":"a1AjjGsgSiN","rbacTenantId":"00E3A2E634FE4137AA97BBE36E691819","region":"cn-shanghai","status":0,"statusLast":0,"thingType":"DEVICE"},scriptData={"downOriginalData":{"code":200,"data":{},"method":"thing.event.property.post","id":"22","message":"success","version":"1.0"},"upOriginalData":"d75db6","upTransformedData":{"method":"thing.event.property.post","id":"22","params":{"bianhao":215,"bianhaoa":93},"version":"1.1"}},useTime=1733,traceId=0b57ff8816077730214073405e5614
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
