mysql 去除表中重复的数据,保留id最小的数据信息
摘要:-- 笨重方法 delete from tb_person WHERE id NOT IN ( select id from (SELECT min(id) id FROM tb_person GROUP BY email having count(1) > 1) tm) and email in 
        阅读全文
            
                posted @ 2020-06-01 11:05
 
                     
                    
                 
                    
                 浙公网安备 33010602011771号
浙公网安备 33010602011771号 
