摘要:
```sql -- 替换json中数据 select SUBSTRING_INDEX(SUBSTRING_INDEX('[{"channelCode":"MOBIL","scale":1400000},{"channelCode":"WXMALL","scale":600000}]','},{',1),'scale":',-1); select replace('[{"channelCode" 阅读全文
posted @ 2020-04-18 20:46
dreamno
阅读(211)
评论(0)
推荐(0)
浙公网安备 33010602011771号