You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/04/03 03:55:27 UTC
[GitHub] [incubator-shardingsphere] zywj opened a new issue #5055: Can it
support cross database join which have different tables
zywj opened a new issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055
```
DB0: user (id, username, class_id)
DB1: class (id, name)
select u.*, c.name as class_name from user u, class c where u.username="test" and u.class_id=c.id
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] zywj edited a comment on issue #5055:
Can it support cross database join which have different tables
Posted by GitBox <gi...@apache.org>.
zywj edited a comment on issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055#issuecomment-608258696
thx. sloved it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #5055: Can
it support cross database join which have different tables
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055#issuecomment-608246389
If db0 and db1 in the same mysql instance, you can query
`select u.*, c.name as class_name from db0.user u, db1.class c
where u.username="test" and u.class_id=c.id `
Otherwise, mysql can't support.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] zywj closed issue #5055: Can it support
cross database join which have different tables
Posted by GitBox <gi...@apache.org>.
zywj closed issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] zywj commented on issue #5055: Can it
support cross database join which have different tables
Posted by GitBox <gi...@apache.org>.
zywj commented on issue #5055: Can it support cross database join which have different tables
URL: https://github.com/apache/incubator-shardingsphere/issues/5055#issuecomment-608258696
thx. slove it.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services