mysql删除重复数据
mysql删除重复数据,只保留相同数据的第一条数据
// sql
delete from ms
where id not in (
select t.id
from (select * from ms GROUP BY name) t)
mysql删除重复数据,只保留相同数据的第一条数据
// sql
delete from ms
where id not in (
select t.id
from (select * from ms GROUP BY name) t)