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

Multiple Database Support? #121

Open
Shu-Ji opened this issue Dec 29, 2023 · 0 comments
Open

Multiple Database Support? #121

Shu-Ji opened this issue Dec 29, 2023 · 0 comments

Comments

@Shu-Ji
Copy link

Shu-Ji commented Dec 29, 2023

I have the a mysql like this:

SELECT *
FROM db1.tb1 tb1_alias
JOIN db2.tb2 tb2_alias ON tb1_alias.<cursor_1> = tb2_alias.<cursor_2>

<cursor_1> will autocomplete, but cursor_2 not.

db1 and db2 in a same mysql server instance.

config:

# Set to true to use lowercase keywords instead of uppercase.
lowercaseKeywords: false
connections:
    -   alias: mysql1
        driver: mysql
        dataSourceName: myuser:mypwd@tcp(127.0.0.1:3306)/db1

If I add db2 in the yml file, still not work:

# Set to true to use lowercase keywords instead of uppercase.
lowercaseKeywords: false
connections:
    -   alias: mysql1
        driver: mysql
        dataSourceName: myuser:mypwd@tcp(127.0.0.1:3306)/db1

    -   alias: mysql2
        driver: mysql
        dataSourceName: myuser:mypwd@tcp(127.0.0.1:3306)/db2

How can auto-complete all databases and tables in one sql file?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant