各位好:
现在有一个字符串 ,包含如下内容:
{"buyId":11773,"goods":
[[610100393,"高贵秀丽",1,"d7"],
[635000011,"青春怒放",1,"d30"],
[862100020,"白色蕾丝",1,"d7"],
[660100043,"个性搭配",1,"d30"],
[650100075,"摩登美眉",1,"d30"],
[680100053,"高帮球鞋",1,"d30"],
[862000020,"魅力在线",1,"d30"]]}
----
现在要解析成如下格式:
ID  n_goods_id  s_name n_num  s_day
11773 610100393 高贵秀丽 1 d7  
11773 635000011 青春怒放 1 d30 
11773 862100020 白色蕾丝 1 d7  
11773 660100043 个性搭配 1 d30 
11773 650100075 摩登美眉 1 d30 
11773 680100053 高帮球鞋 1 d30 
11773 862000020 魅力在线 1 d30 请问 有什么好的办法?SQL