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.

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

Ability to create a connection without database name (cross-database query) #1077

Open
storm1er opened this issue Jan 3, 2023 · 3 comments
Labels
feature request New issue opened using "Feature request" template mysql MySQL / MariaDB driver

Comments

@storm1er
Copy link

storm1er commented Jan 3, 2023

Is your feature request related to a problem? Please describe.
Explicit title: As we can't create a connection without a database name, we can't execute cross-database query

Use case: I have 20 databases on the same MySQL server. There's no workaround to run the same query 20 times, the only way is to create a connection for each database even if it's on the same server.

Describe the solution you'd like

  • Ability to create a connection without giving a database name
  • Ability to run a request without a given database name

Describe alternatives you've considered
No workaround is available for now except running the cross-database request using another software

@storm1er storm1er added the feature request New issue opened using "Feature request" template label Jan 3, 2023
@gjsjohnmurray gjsjohnmurray added the mysql MySQL / MariaDB driver label Jan 6, 2023
@gjsjohnmurray
Copy link
Collaborator

Related to #727

@gjsjohnmurray
Copy link
Collaborator

When you connect to your MySQL server does the tree show all 20 databases, with the one you named in the connection being first, followed by the other 19 in alpha order?

When you run a SELECT in which you prefix the table name(s) with databasename. do you get the data from the expected place?

@storm1er
Copy link
Author

For now the workaround has been to create a connection using "mysql" as database name (config database) ... I'm able to see all databases afterwards

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New issue opened using "Feature request" template mysql MySQL / MariaDB driver
Projects
None yet
Development

No branches or pull requests

2 participants