spring - mysql 如何实现多表跨库联合查询？

Answer 1

There are also many queries related to cross-database tables in my project, which are very simple to implement:

    select 
        a.uid  
    from 
       ucenter.user a , database user_profile b 
   where a.uid = b.uid;

Just add the library name in front of the table.

This is an example of xml in my project. The project uses springmvc, and the persistence layer framework is mybatis:

Data source configuration of the project: