mysql 有条件地计算行数 count计数

mysql 有条件地计算行数 count计数第一种不符合的返回null,使用count函数select COUNT(IF(id > 0 , id, null)) from user group by id;使用sum,将不符合的返回0,符合返回1Select A,count(B) as total,sum(case when B > 30 then 1 else 0 end) as total1,sum(case when B > 20 then 1 else 0 end) as total2 from ABC group by A

layui时间选择框容器高度不够闪退问题

解决layui时间选择框容器高度不够闪退问题加上trigger: 'click'laydate.render({ elem: "#inDate", trigger: 'click'});