08 2022 档案

根据指定字段去重
摘要：DELETE FROM tongfu_user_statistics WHERE 1=1 AND `user_id` in (SELECT * FROM ( (SELECT `user_id` `names` FROM tongfu_user_statistics GROUP BY user_id 阅读全文
posted @ 2022-08-04 16:34 垖垏尐 阅读(28) 评论(0) 推荐(0) 编辑
计算字符串中逗号最多的有多少个
摘要：SELECT id, LENGTH(path) - LENGTH(REPLACE(path, ',', '')) FROM tongfu_user where LENGTH(path) - LENGTH(REPLACE(path, ',', '')) = ( select max(LENGTH(pa 阅读全文
posted @ 2022-08-04 16:33 垖垏尐 阅读(17) 评论(0) 推荐(0) 编辑
根据不同条件分别求和
摘要：$balanceMoney = $balanceModel ->where(['user_id'=>$v['id']]) ->field("sum(CASE WHEN type = '17' THEN money ELSE 0 END) as money, sum(CASE WHEN type = 阅读全文
posted @ 2022-08-04 16:15 垖垏尐 阅读(37) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示