Jump to content
enim

Since I started, I've wanted MySQL spell check...

Recommended Posts

Turns out, you can - kind of.

 

I was turned on to Sublime Text by a friend of mine, and realized that you can do a really off-the-beaten-path version of spellcheck with it.  I have a few different base documents I use for my DBs, and just copied a 'show tables', and a few descs to the bottom of them.  Sublime will attempt to auto-match while you are typing, if you have it set to SQL syntax (which is super easy, I think its command+p, type sql, hit enter - its so programmed into my brain I don't think about it).

 

Theres also a "send to terminal" package, the name of which I don't remember.  I'm sure its an easy Google.

 

So, just a heads up for those of you who fat-finger like I do.

Share this post


Link to post
Share on other sites

Ah, are you saying it does auto predict of table names as it's connected to the database or just a spell checker?

 

That's why I love Microsoft SQL Server as the predictive text in the management studio is awesome.

Share this post


Link to post
Share on other sites

Sublime actually reads syntax live, and will figure out table names and such based on what else is in the text doc.  Its an IDE.  I can't use mysql tab complete since it takes way too long on startup (4 or 5 schemas, with 60-100 tables, with 6-50 columns...)

Share this post


Link to post
Share on other sites

Ah gotcha, I've recently started using an IDE - PHPStorm.  It's incredible.  I used to only use Notepad++ but the IDE is far better. 

 

I have yet to set it up to the database to do predictive table names/field names.  I didn't take the time to see how to setup, but planning on it.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×