1 2 3 4 |
select DATE_FORMAT(create_time,'%Y%u') weeks,count(caseid) count from tc_case group by weeks; select DATE_FORMAT(create_time,'%Y%m%d') days,count(caseid) count from tc_case group by days; select DATE_FORMAT(create_time,'%Y%m') months,count(caseid) count from tc_case group by months; select DATE_FORMAT(create_time,'%Y') years,count(caseid) count from tc_case group by years; |
分类目录归档:SQL
MyBatis Generator与MySQL遇见的坑
项目中MyBatis的model,dao,mapping文件都是用MyBatis Generator生成的,这个工具确实方便好用,但是使用过程也碰到过坑。