mysqldump -uroot -pmysql eedu activity > /usr/developer/export_files/activity.sql

重命名表
rename table activity_zs_statistics_info_test to activity_zs_statistics_info;
查看建表SQL
show create table user;

SELECT DATE_FORMAT(create_date,'%Y-%m-%d') as time,sum(pv) pageview 
FROM page_view  where create_date>'2018-04-01'  GROUP BY  time;

delete FROM `facility_serial_number` where serial_number in(
SELECT serial_number
FROM `facility_serial_number_test` 
GROUP BY serial_number 
HAVING COUNT(*) >1)
and id not in (select min(id) from `facility_serial_number_test` group by serial_number having count(*)>1)
create table facility_serial_number_test select * from facility_serial_number;