Skip to content
New issue

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

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

Already on GitHub? # 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?

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

No branches or pull requests

1 participant