search

mtxr / SublimeText-SQLTools

SQLTools for Sublime Text 3
https://code.mteixeira.dev/SublimeText-SQLTools/
GNU General Public License v3.0
177 stars 40 forks source link

setup conn #217

Closed slloyd88 closed 5 years ago

slloyd88 commented 5 years ago

The readme needs to explain how to setup your connection after installatioin

tkopets commented 5 years ago

There is a section about Connections on the website (see link below). https://code.mteixeira.dev/SublimeText-SQLTools/

Readme most probably should point to the relevant section of the website. If we duplicate this info in Readme and website it will require additional time to maintain both descriptions to keep them in sync.

tkopets commented 5 years ago

Have you managed to set up your connections?

slloyd88 commented 5 years ago

Working on it now. Hey, so if I have a php page and am coding a SQL query, can I highlight the SQL and run it? What if I have multiple databases? Can I have more than one Mysql databases?

tkopets commented 5 years ago

Hey, so if I have a php page and am coding a SQL query, can I highlight the SQL and run it?

If your selection is a valid SQL query, then yes. But if your SQL is built by string concatenation or contains some kind of parameters then most probably no.

What if I have multiple databases? Can I have more than one Mysql databases?

Create multiple connections via ST: Setup Connections - one connection for each database. You can switch between those connections via ST: Select Connection.

slloyd88 commented 5 years ago

Sweet. My Oracle connection failed because it uses a SID not a service. I tried to specify the SID in the settings but it failed.

tkopets commented 5 years ago

Readme now has configuration section and links to the website for further details.