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

[enim]

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.

[Nathan]

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.

[enim]

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...)

[Nathan]

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.