Thread: IDE for MySQL?

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Location
    New York City
    Posts
    4
    Rep Power
    0

    Question 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?
  2. #2
  3. Lord of the Dance
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Oct 2003
    Posts
    3,663
    Rep Power
    1958
    try take a look at HeidiSQL.
  4. #3
  5. No Profile Picture
    Problem Solver
    Devshed Specialist (4000 - 4499 posts)

    Join Date
    Jan 2001
    Location
    Stockholm, Sweden
    Posts
    4,495
    Rep Power
    534
    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.

    BTW:
    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.
    /Stefan
  6. #4
  7. SQL Consultant
    Devshed Supreme Being (6500+ posts)

    Join Date
    Feb 2003
    Location
    Toronto Canada
    Posts
    27,207
    Rep Power
    4279
    another vote for HeidiSQL, which i've been using for years (since it used to be known as MySQL-Front)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
  8. #5
  9. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2009
    Posts
    225
    Rep Power
    11
    Try dbForge Studio for MySQL, there are some editions, Express edition is free, Standard and Professional has Stored routine and script debugging framework.

    dbForge Studio for MySQL Editions

    dbForge Studio for MySQL Overview
    Devart Company,
    MySQL management tools
    http://www.devart.com/dbforge/mysql/
  10. #6
  11. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2008
    Location
    New York City
    Posts
    4
    Rep Power
    0

    Thumbs up Thank You!


    Thank you guys for feedback. I checked all the links and bookmarked them. I appreciate your help.

IMN logo majestic logo threadwatch logo seochat tools logo