manitod的博客

mysql批量修改表结构

GIS相关的空间计算函数

mysql深分页优化方案

深入检出MYSQL查询索引失效

mysql直接查询中位数 mysql无直接查询中位数的函数median,实现方式有多种 SELECT AVG(dd.val) as median_val FROM ( SELECT d.val, @rownum:=@rownum+1 as `row_number`, @total_rows:=@rownum FROM data d, (SELECT @rownum:=0) r WHERE d.val is NOT NULL -- put some where clause here ORDE

自然日周月季年分组 SELECT new_date as submitDate, ROUND(check_right/(check_count + check_add)*100,2) as rightRate, stat_time as statTime FROM ( SELECT <choose> <when test="fieldCollectIndexReq.statCycle == &quot;Y&quot;"> DATE