mysql数据去重
根据name去重tableA 表:
DELETE
FROM tableA
WHERE id NOT IN (select aa
from (SELECT MAX(id) aa
FROM tableA
GROUP BY name) a);
mysql数据去重
根据name去重tableA 表:
DELETE
FROM tableA
WHERE id NOT IN (select aa
from (SELECT MAX(id) aa
FROM tableA
GROUP BY name) a);