mysql5.5不兼容5.6sql文件_为什么这段sql在我的电脑上可以执行，另外一台不可以。使用的mysql5.6 另一台是5.5...

selectname,sum(casewhenmonth(lastlogin)=1andyear(lastlogin)=2014then1else0end)一月,sum(casewhenmonth(lastlogin)=2andyear(lastlogin)=2014then1else0end)二月,sum(casewhenmon...

select name,

sum(case when month(lastlogin) = 1 and year(lastlogin) =2014 then 1 else 0 end) 一月,

sum(case when month(lastlogin) = 2 and year(lastlogin) = 2014 then 1 else 0 end) 二月,

sum(case when month(lastlogin) = 3 and year(lastlogin) = 2014 then 1 else 0 end) 三月,

sum(case when month(lastlogin) = 4 and year(lastlogin) = 2014 then 1 else 0 end) 四月,

sum(case when month(lastlogin) = 5 and year(lastlogin) = 2014 then 1 else 0 end) 五月,

sum(case when month(lastlogin) = 6 and year(lastlogin) = 2014 then 1 else 0 end) 六月,

sum(case when month(lastlogin) = 7 and year(lastlogin) = 2014 then 1 else 0 end) 七月,

sum(case when month(lastlogin) = 8 and year(lastlogin) = 2014 then 1 else 0 end) 八月,

sum(case when month(lastlogin) = 9 and year(lastlogin) = 2014 then 1 else 0 end) 九月,

sum(case when month(lastlogin) = 10 and year(lastlogin) = 2014 then 1 else 0 end) 十月,

sum(case when month(lastlogin) = 11 and year(lastlogin) = 2014 then 1 else 0 end) 十一月,

sum(case when month(lastlogin) = 12 and year(lastlogin) = 2014 then 1 else 0 end) 十二月

from (select * from info where name='合川区古楼镇' and year(time) = '2014' group by lastlogin)as total group by name

展开

总结

以上是生活随笔为你收集整理的mysql5.5不兼容5.6sql文件_为什么这段sql在我的电脑上可以执行，另外一台不可以。使用的mysql5.6 另一台是5.5...的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。