weixin_43830264的博客

取两条相邻数据之间的时间差SELECT A.id,A.createDate,B.createDate,TIMESTAMPDIFF(MINUTE,A.createDate,B.createDate) mins FROM( SELECT a.*,(@i := @i + 1) AS ord_num FROM ${tableName} a,(SELECT @i := 1) d ORDER BY a.createDate ) AS A LEFT JOIN ( SELE

mysql 递归查询语句：WITH RECURSIVE cte AS(SELECT a.Id , a.name FROM t_base a WHERE a.Id = ‘1’UNION ALLSELECT k.Id ,CONCAT(c.name, ’ > ’ ,k.name ) FROM t_baseStruct k INNER JOIN cte c ON c.Id = k.Pid WHERE k.isDel = ‘0’)SELECT Id ,name FROM cte...