菜鸟

摘要： 删除表中重复记录，只保留一条： delete from 表名 where 字段ID in (select * from (select max(字段ID) from 表名 group by 重复的字段 having count(重复的字段) > 1) as b); 实例： 2.当想要为某一个表建立一 阅读全文