mmdxgj的博客

需求描述：需要对ef_order表中car_model_info（json类型）字段中的seriesCode进行group by并计数未生效的写法：select json_extract(car_model_info,'$.series_code') AS series_code,count(*) from ef_order where pay_method=1 and status=100 and dealer_id=14 group by series_code运行结果：未进行分组

delimiter $$ --结束符为 $$DROP PROCEDURE IF EXISTS mytest; --判断进程是否存在，存在则删除CREATE PROCEDURE mytest() --新建进程BEGINdeclare i bigint(20) DEFAULT 1837; DECLARE ti bigint(20) DEFAULT 128693;DECLARE tn ...