2022年8月4日
根据指定字段去重
摘要： 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 垖垏尐 阅读(24) 评论(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 垖垏尐 阅读(15) 评论(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 垖垏尐 阅读(35) 评论(0) 推荐(0) 编辑