shardingjdbc再日期分表联表查询

93 阅读 0 评论 62 点赞

我是靠谱客的博主谨慎毛巾，这篇文章主要介绍shardingjdbc再日期分表联表查询，现在分享给大家，希望可以做个参考。

shardingjdbc再日期分表联表查询时，绑定表——联表查询防止出现笛卡尔积现象

复制代码

1
2
3
4
5
6
7
8
im_msg_base:
          actual-data-nodes: master1.im_msg_base_$->{2020..2021}$->{(1..12).collect{t ->t.toString().padLeft(2,'0')}}$->{(1..31).collect{t ->t.toString().padLeft(2,'0')}}

im_msg_content:
          actual-data-nodes: master1.im_msg_content_$->{2020..2021}$->{(1..12).collect{t ->t.toString().padLeft(2,'0')}}$->{(1..31).collect{t ->t.toString().padLeft(2,'0')}}


binding-tables[0]: im_msg_base,im_msg_content

SQL语句：

复制代码

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
select t.id,
        t.comm_id,
        t.msgid,
        t.fromuid,
        t.touid,
        t.msg_type,
        t1.content,
        t.chat_type,
        t.status,
        t.readflag,
        t.sendtime,
        t.createtime,
        t.lifetime
        from im_msg_base t
        inner join im_msg_content t1 on t.id = t1.base_id
        where t.createtime between #{begin} and #{end} and t1.createtime between #{begin} and #{end}