Excel相关知识点
(1)名称管理器——Name Manager
【CoderBaby】首先需要创建多个名称(包含key及value),作为下拉列表的数据源,供后续通过名称引用。...parent_area_id` int DEFAULT NULL,
PRIMARY KEY (`area_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4...COLLATE=utf8mb4_0900_ai_ci |
初始化数据
省级数据:
NSERT INTO area(area_name,area_desc) VALUES ("四川","四川省"),(...INTO area(area_name,area_desc, parent_area_id) VALUES ("西湖","西湖区", 7),("江干","江干区", 7),("鹿城","鹿城区", 8)...,("龙湾","龙湾区", 8),("上虞","上虞区", 9),("越城","越城区", 9),("江北","江北区", 10),("镇海","镇海区", 10);
INSERT INTO area(