caiyong_的博客

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_...

mysql数据库中按天统计数据SELECTDATE_FORMAT(orderTime, ‘%Y-%m-%d’) as time, sum(payout),count(1) FROMorder_detail WHEREorderTime BETWEEN ‘2019-09-01 00:00:00’AND ‘2019-10-31 23:59:59’ group by time order by...

1.创建新增1百万条数据存储过程DROP PROCEDURE IF EXISTS cunchu; CREATE PROCEDURE cunchu()        BEGIN          declare i int;           set i = 1;           while i<1000000 do                  INSERT INT...