March 15th, 2010, 11:35 AM
IDE for MySQL?
I'm just starting to dabble in MySQL, and having learned what a timesaver a debugger can be in programming, I am wondering if there is an IDE for MySQL. It seems to have its own command-line environment along with its own debugging functionality, so I'm not sure. Would I ever need a counterpart of NetBeans for MySQL?
March 15th, 2010, 03:54 PM
March 15th, 2010, 04:06 PM
There's a huge bunch of them both free and commercial and here are just a few free examples that I have tested: MySQL Workbench, SQLYog and Toad for MySQL.
Personally I use Toad for MySQL but that is probably mostly because one of my friends is one of the core developers. And after I tried it out a couple of years back I liked it and haven't had a reason to change.
Yes you really want to use an IDE. If not for something else just to get syntax highlighting and indentation/reformat help for your SQL statements.
Although it is good to start out with the CLI and learning to write all the alter table statements, selects etc you still get a lot from using a IDE.
Last edited by sr; March 15th, 2010 at 04:10 PM.
March 15th, 2010, 09:16 PM
another vote for HeidiSQL, which i've been using for years (since it used to be known as MySQL-Front)
March 16th, 2010, 02:31 AM
March 16th, 2010, 02:25 PM
Thank you guys for feedback. I checked all the links and bookmarked them. I appreciate your help.