不知道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