mysql知识点汇集

最新推荐文章于 2025-09-11 20:53:34 发布

转载最新推荐文章于 2025-09-11 20:53:34 发布 · 64 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/ywjfx/p/10107389.html

文章标签：

#数据库

1、将两个表字段类型一致的数据合并到一个新表的命令。

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;

2、对每一天的数据进行统计，并输出到一个excel文件中。

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"