mysql
筱F
这个作者很懒,什么都没留下…
展开
-
2021-07-09sql优化:时间筛选索引无效时
sql优化:订单表数据百万级别:时间字段筛选索引未生效的情况在mapper文件的sql 中加入:force index (MPOS_ORDER_TRANS_TIME)判断时间筛选生效才启用:<if test="(params.beginTranTime != null and params.beginTranTime !='')||(params.endTranTime!= null and params.endTranTime !='')"> force index (MPOS原创 2021-07-09 15:04:56 · 322 阅读 · 0 评论 -
Mysql查询本天,本周 ,本月的上个月的数据
今天select * from 表名 where to_days(时间字段名) = to_days(now());昨天SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) <= 1近7天SELECT * FROM 表名 where DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= date(时间字段名)近30天SELECT * FROM 表名 where DATE_SUB(CURDAT转载 2020-12-17 17:22:05 · 122 阅读 · 0 评论 -
多表关联查询数量
//多表关联查询数量select user, t1.count1, t2.count2from user tleft join (select user_id, count(sport_type) as count1from sport group by user_id) t1on t.id = t1.user_idleft join (select user_id, count(level) as count2from grade group by user_id) t2on t.原创 2020-12-17 17:08:46 · 1246 阅读 · 0 评论 -
mysql之插入,清理,更新的多表组合操作
mysql之删除单表内的重复数据DELETE FROM plat_positionWHERE position_id IN ( SELECT tp.position_id FROM ( SELECT ta.position_id FROM plat_position AS ta WHERE ta.position_id <> ( SELECT max(tb.position_id)原创 2020-08-22 11:09:50 · 152 阅读 · 0 评论