Teacher H
删除重复数据 只保留一条数据
# 查询重复数据
SELECT
m.ma_code,
count( 1 )
FROM
bi_matierals_copy1 m
GROUP BY
m.ma_code
HAVING
count( 1 ) > 1;
# 删除重复数据,并保留一行
DELETE
FROM
bi_matierals_copy1 AS ta
WHERE
ta.id <> (
SELECT
t.maxid
FROM
( SELECT max( tb.id ) AS maxid FROM bi_matierals_copy1 AS tb WHERE ta.ma_code = tb.ma_code ) t
);
王哥
起别名 防止报错!