gunzip < test.sql.gz | mysql -u root -p'123' databasename
* 查询两个库重复数据
select count(0) from `databasename`.tablename where enterprise_name in(select enterprise_name from(SELECT t.enterprise_name,COUNT(*) AS COUNT FROM( SELECT enterprise_name FROM copy0.tablename UNION ALL SELECT enterprise_name FROM `databasename`.tablename) t GROUP BY t.enterprise_name HAVING COUNT(*)>1)t1 );
delete from `databasename`.tablename where enterprise_name in(select enterprise_name from(SELECT t.enterprise_name,COUNT(*) AS COUNT FROM( SELECT enterprise_name FROM copy0.tablename UNION ALL SELECT enterprise_name FROM `databasename`.tablename) t GROUP BY t.enterprise_name HAVING COUNT(*)>1)t1 );
delete from `databasename`. tablename where enterprise_name in(select enterprise_name from(SELECT t.enterprise_name,COUNT(*) AS COUNT FROM( SELECT enterprise_name FROM copy0.tablename UNION ALL SELECT enterprise_name FROM `databasename`.tablename) t GROUP BY t.enterprise_name HAVING COUNT(*)>1)t1 );