标签：删除 no 重复 t1 weighbridge record Mysql serial id
一、背景
二、实现
查看表的重复数据条数
SELECT count(1) a,serial_no FROM `mud_weighbridge_record` GROUP BY serial_no HAVING a >1 ;
删除表的重复数据
DELETE t1 from
mud_weighbridge_record t1
inner join (SELECT min(record_id) record_id,serial_no,count(1) FROM mud_weighbridge_record GROUP BY serial_no HAVING count(1) >1) t2
on t1.serial_no = t2.serial_no
where t1.record_id > t2.record_id;
三、遇到的报错
四、参考博客
标签：删除,
no,
重复,
t1,
weighbridge,
record,
Mysql,
serial,
id
From： https://www.cnblogs.com/lcaiqin/p/17792726.html