mysql 删除重复的记录、A表字段更新到B表

 -- A表字段更新为B表的字段值，条件A\B表通过id关联的记录
update b_table as b set b.`name` = (select a.name FROM a_table as a where b.id=a.id) 
 where EXISTS(select * from a_table as c where c.id=b.id); 

-- A表记录insert到B表，条件是B表不存在A表的记录

insert into b_table(id,name) SELECT id,name from a_table as a
where not EXISTS(select * from b_table as b where b.id=a.id); 

-- 删除重复的记录，只保留一条(id最小的记录)

delete from b_table where `name` in(
    SELECT t1.name from(
        SELECT bc.name from b_table as bc where 1=1 GROUP BY bc.name HAVING count(*)>1
    ) as t1
) AND id NOT IN (
    SELECT t2.rowid from(
        SELECT min(c.id) as rowid,c.name FROM b_table as c GROUP BY c.name HAVING count(*) > 1) as t2
);

-- SELECT bc.`name`,count(id) from b_table as bc where 1=1 GROUP BY bc.`name` HAVING count(*)>1;