mysql提取json字段类型中的数据

INSERT

INSERT INTO smbht_db.`clt_wx_fy_orders_gdt` (created_at,user_phone,package_price,type_name,type_sub1,type_sub2,type_sub3,type_sub4)
SELECT 
created_at,user_phone,package_price,
JSON_UNQUOTE(json_extract(goodsType,'$.type_name')) type_name,
json_extract(goodsType,'$.type_sub1') type_sub1,
json_extract(goodsType,'$.type_sub2') type_sub2,
json_extract(goodsType,'$.type_sub3') type_sub3,
json_extract(goodsType,'$.type_sub4') type_sub4 
FROM wxads.wx_fy_orders

UPDATE

UPDATE clt_wx_fy_orders_mp  a
INNER JOIN
(SELECT 
id,created_at,user_phone,package_price,
JSON_UNQUOTE(json_extract(goodsType,'$.type_name')) type_name,
json_extract(goodsType,'$.type_sub1') type_sub1,
json_extract(goodsType,'$.type_sub2') type_sub2,
json_extract(goodsType,'$.type_sub3') type_sub3,
json_extract(goodsType,'$.type_sub4') type_sub4 
FROM clt_wx_fy_orders_mp) b ON a.`id`=b.id
SET a.`type_sub1`=b.type_sub1,a.`type_sub2`=b.type_sub2,a.`type_sub3`=b.type_sub3,a.`type_sub4`=b.type_sub4