select coalesce(count(multiIf(t.is_in_stock='是',1,null)),0) as value_1, coalesce(count(multiIf(t.is_in_stock='是',null,1)),0) as value_0, coalesce(round(count(1),2),0) as total…

mysql 中使用 json 查询，解析 json 数据 使用 json_extract() select so.order_id,so.user_phone,so.real_name,so.user_address,so.user_phone,json_extract(esoci.cart_info, '$.productInfo.store_n…