MySQL语句删除数据库中某列相同和重复的记录数据行保留其中任一个 方法一:利用3条SQL语句实现(采用临时数据表tmp进行转换) create table tmp as select min(ID) as col1 from content group by name; delete from content where id not in (select col1 from tmp); drop table tmp; 方法二:利用PHP程序实现, 利用select * from content where ID in( select min(ID) as col1 from content group by name)找出不相同的记录,读取出来,再存入另一个数据表。