贾廷帅的博客

最全MySQL explain 字段详解

前言我们在sql里面经常看到 distinct 和 group by,那么两者到底有何区别呢？下面就来一探究竟。首先来看官方描述链接: Mysql distinct 传送门其中有这么一段描述：Generally speaking, the DISTINCT clause is a special case of the GROUP BY clause. The difference between DISTINCT clause and GROUP BY clause is that the G