基站多小区数据合并为基站数据

USE test;

DROP TABLE IF EXISTS cell;

CREATE TABLE `test`.`cell`(
        `id` INT NOT NULL,
        `小区名称` VARCHAR(255)  NULL,          
        `基站名称` VARCHAR(255)  NULL //最后一项不能有逗号，否则会报错
    );
    
INSERT INTO `cell`(id,小区名称,基站名称) VALUES 
(1,"小区_11","基站1"),
(2,"小区_12","基站1"),
(3,"小区_13","基站1"),
(4,"小区_21","基站2"),
(5,"小区_22","基站2"),
(6,"小区_23","基站2"); //char类型的数据需要用单引号或者双引号括起来

CREATE TEMPORARY TABLE to_delete (`基站名称` VARCHAR(255) NOT NULL, delete_id INT NOT NULL);  
 
INSERT INTO to_delete(基站名称,delete_id)  
SELECT 基站名称, MIN(id) FROM cell GROUP BY 基站名称 HAVING COUNT(*) > 1 UNION SELECT 基站名称, MAX(id) FROM cell GROUP BY 基站名称 HAVING COUNT(*) > 1;  

SELECT * FROM cell WHERE id NOT IN (SELECT delete_id FROM to_delete);