魅力峰值

导航

12 2020 档案

Mysql8的分组排序
摘要:Mysql8之前Group By支持分组排序 如: select * from ( select * from user_position order by userId,time desc ) as u group by u.userId 或如: select * from user_positi 阅读全文

posted @ 2020-12-30 17:57 魅力峰值 阅读(2139) 评论(0) 推荐(2)

Mybatis的test字符串比较
摘要:使用<choose>标签 如: <choose> <when test="query.auditType != null and query.auditType == '2'"> AND ci.audit_status = '2' </when> <otherwise> AND ci.audit_s 阅读全文

posted @ 2020-12-30 16:13 魅力峰值 阅读(1035) 评论(0) 推荐(0)