INSERT into new_table(user_name,password,age) SELECT user_name,password,age FROM old_table1;

INSERT into new_table(user_name,password,age) SELECT user_name,password,age FROM old_table2;

select * from (select

    DATE_FORMAT(e.create_Time,'%Y年%m月%d日') as time,

    sum( e.actionorder_number) as '激活数',

    sum( e.neworder_number) as '新增数',

    sum( e.unsub_number ) as '退订数'

from extract_order_info e

WHERE

     e.create_Time BETWEEN '2018-10-01' and '2018-10-25'

GROUP BY time

ORDER BY time) f INTO OUTFILE "D:\1.xls"