![](https://img-blog.csdnimg.cn/20201014180756913.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
caiyong_
这个作者很懒,什么都没留下…
展开
-
mysql常用语句随笔
mysql中常用sql语句 分表后跨表查询 select DATE_FORMAT(tmp.creatTime, ‘%Y-%m-%d’) as time,count(1),sum(tmp.coin) from (select * from table_201910 UNION ALL select * from table_201911 UNION ALL select * from table_...原创 2019-12-05 19:37:29 · 147 阅读 · 0 评论 -
mysql数据库中按天统计数据
mysql数据库中按天统计数据 SELECT DATE_FORMAT(orderTime, ‘%Y-%m-%d’) as time, sum(payout),count(1) FROM order_detail WHERE orderTime BETWEEN ‘2019-09-01 00:00:00’ AND ‘2019-10-31 23:59:59’ group by time order by...原创 2019-11-05 00:17:56 · 1675 阅读 · 0 评论 -
mysql中简单存储过程创建和调用
1.创建新增1百万条数据存储过程 DROP PROCEDURE IF EXISTS cunchu; CREATE PROCEDURE cunchu() BEGIN declare i int; set i = 1; while i<1000000 do INSERT INT...原创 2019-01-18 12:59:43 · 643 阅读 · 1 评论