utf8mb4_0900_ai_ci |
初始化数据
省级数据:
NSERT INTO area(area_name,area_desc) VALUES ("四川","四川省"),("浙江","浙江省"),("广东...","广东省");
市级数据:
INSERT INTO area(area_name,area_desc, parent_area_id) VALUES ("南充","南充市", 1),("成都","..., ("广元","广元市", 1),("杭州","杭州市", 2),("温州","温州市", 2),("绍兴","绍兴市", 2),("宁波","宁波市", 2),("广州","广州市", 3),("佛山...","佛山市", 3);
县级数据:
INSERT INTO area(area_name,area_desc, parent_area_id) VALUES ("西充","西充县", 4),("仪陇"...天河","天河区", 11),("顺德","顺德区", 12),("南海","南海区", 12);
(2)实现逻辑说明
递归查询数据源表(area),构建“以parent_area_id为key,子区域名称列表为