![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
W_GJ
进阶菜鸟
展开
-
mysql 常见数据分析,统计数据 工作应用场景
-- 原始数据 select c.system as `系统名`,a.srv_name as `服务`, DATE_FORMAT(a.created_at, '%Y %m') as `发布月份`, a.version as `制品版本` , pc.deploy_cluster_name as `发布集群` , b.`project_name` as `coding项目名称`, b.attribute as `发布特性`, a.created_at as `发布时间`, a.updated_at as `原创 2021-12-02 15:27:17 · 818 阅读 · 0 评论 -
mysql 执行计划 explain 的 应用
mysql> explain select * from user where user_id = (select user_id from acticle where article_id = 33) union select * from user where user_id = (select user_id from acticle where article_id = 14) \G...原创 2019-11-30 16:55:24 · 91 阅读 · 0 评论