MYSQL 删除地址信息表重复的地址信息。。SQL脚本如下
DELETE
FROM
t_epam_address_level_one
WHERE
level_one_id NOT IN (
SELECT
level_one_id
FROM
(
SELECT
MIN(level_one_id) AS level_one_id
FROM
t_epam_address_level_one
GROUP BY
TRIM(`code`)
) templateTable
);