When I pull in a new window and drop it in the editing area it is not put where I dropped it. The diagram editor is not so user friendly either. It should add a new row when I press 'down' in the last row or click the mouse in the first blank row. That's not as 'excel-like' as I'd like to see it. While you are in 'data' view and want to add a new row (data) to the table, you need to create that row by pressing a button first. It does support character encodings (collations), though. I just gave Toad for MySQL a quick glimpse:Įditing Tables is in the same way cumbersome as it is in HeidiSQL: When you try to add another column, a new window opens where you enter the columns properties. But there definitely is room for improval. So far HeidiSQL was one of the best application's I've tried. It does not have a diagram functionality.

Also it does not support character encoding, so I can't set my tables to 'UTF-8'.

I can give you an response to HeidiSQL at once, because that's one of the application's that I used before:Įditing tables is a bit cumbersome, because most of the column's properties have to be edited in another window. I'm going to test the recommended applications and give you an answer when I'm done. Is there any application that you can recommend to me? Free would be a plus, but anything up to $100 would be okay, too. because I mainly use MyISAM (which doesn't support constraints). Nice to have: I'd like to have a feature that's comparable to the database diagrams in the Management Studio, where I can visualize 'foreign key relations' between tables. Should be as easy as editing an Excel sheet. Same applies to adding new rows to the table. What I want is adding a new row in a 'column-list table' as it is done in the Management Studio. I have two requirements and one 'nice to have' feature:Įditing table structure should not be a pain in the a** -> I don't want to click an 'add another column' button, then edit the column's properties in a new window. Are there any MySQL Client applications for Windows that get even close to what the Enterprise Manager / Server Management Studio is for Microsoft SQL?

Mysql gui client windows