架构如下所示:
有一种方法:
delete t1 from mytable t1 inner join mytable t2 on t2.brand = t1.brand and t2.model = t1.model and t2.id < t1.id
这将删除上的重复项 (brand, model) 同时保留最小id的那个。
(brand, model)
