SQL删除重复数据

2022年7月26日 星期二

删除重复数据

SELECT b.idcard,COUNT(*) as snum FROM `fa_resident` as b 
where 
cast(b.createtime as signed)>unix_timestamp('2022-07-26 00:00:00') 
GROUP BY b.idcard 
HAVING snum>1;

删除单条指定数据

"DELETE FROM `fa_resident` WHERE idcard='".$idcard."' AND cast(createtime as signed)>unix_timestamp('2022-07-26 00:00:00')";