Nio的博客

select @j := @j + 1 monfrom 表名, ((select @n := 17 - DATE_FORMAT(STR_TO_DATE('2019-12-09 15:33', '%Y-%m-%d %H:%i:%s'), '%H')) b), (select @j := 24 - @n) cwhere @j < 24unionSELECT @m :...

系统开发中有如下SQL语句：SELECT c.customer_id, c.customer_name, c.sex, c.tel, c.is_verification AS verificationFlg, c.salesman, ...

查询一年十二个月：SELECT CASE WHEN length(mon) = 1 THEN CONCAT('0', mon) ELSE mon END monthsFROM (SELECT @m := @m + 1 mon FROM 表名称随便, (SELECT @m := 0) ...