1:统计已过15天的记录
TIMESTAMPDIFF(DAY, os.CreateTime, now()) >= 15 2:统计昨日数据 date(createtime) = date_sub(curdate(), INTERVAL 1 DAY) 3:when then流程控制 WHEN 'MK' THEN ( SELECT MarketName_cn FROM market WHERE b.ObjectId = MarketId ) END AS market 4:逗号连接一字段中数据连接 GROUP_CONCAT(industrybeltMarket) AS industrybeltMarket GROUP BY a.id 5:查询是否存在 find_in_set( ( SELECT MemberRankId FROM member WHERE memberId = #{memberId} ), MemberRanks ) 6:存在函数 EXISTS |
工作中使用Mysql遇到的问题汇总,不定时更新
最新推荐文章于 2024-04-01 16:41:07 发布