Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

怎么进行多库联查？ #69

Open
xzblog opened this issue Jul 15, 2019 · 1 comment
Open

怎么进行多库联查？ #69

xzblog opened this issue Jul 15, 2019 · 1 comment

Comments

@xzblog
Copy link

xzblog commented Jul 15, 2019

假如我有 A, B两个数据库
A库有个admin_account表用于存管理员数据
B库有个comment_info表用于存评论数据
B库得comment_info表中有一个字段adminId对应着A库admin_account的id
现在我查询B库comment_info中的评论数据的时候，想联合查询出A表中id=adminId的数据。
@kuangshp
Copy link

假如我有 A, B两个数据库
A库有个admin_account表用于存管理员数据
B库有个comment_info表用于存评论数据
B库得comment_info表中有一个字段adminId对应着A库admin_account的id
现在我查询B库comment_info中的评论数据的时候，想联合查询出A表中id=adminId的数据。

自己使用query写sql语句了

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@kuangshp @xzblog