MySQL Query Browser is a database querying tool that combines the simplicity of a Web-browser-like interface with powerful features like multiple result sets on tab sheets, query history, storing query "bookmarks", editing and comparing resultsets, SQL script debugging, and more. It is released under the GPL and is available with native interfaces for Mac OS X, Windows and Linux.
It does exactly what you want - shows the tables, their fields, runs queries. Works perfectly.
Cons
Nothing at all
Summary
Interesting but unstable for me
inchHIGH
Pros
Cons
Summary
This review was originally posted on VersionTracker.com.<br />I have hopes for this product, but it's hard to test when it crashes so much.
Also, the screen I'm presented with does not match the one in the tutorials, I'm not talking about the fact that the screenshots in the tutorials are from win XP. I'm talking about the fact the there is a bar they show in the tutorials for building the queries, they show buttons for SELECT, HAVING, WHERE etc which are not on in my window. I can't find a preference or anything to turn this on, so I'm stumped about that.
Also, when I drag a table into the drag area and drop it on any of the JOIN options, I can't get it to work. It says they need to be innoDB tables or they have to have a column with the same name, I have columns of the same name but it never adds anything to the query.
I'm happy to see mysql supporting OS X, but this product seems from ready for prime time.
Stability issues
wade7
Pros
Cons
Summary
This review was originally posted on VersionTracker.com.<br />I'm using v1.1.17 on 10.4.3 and am unable to use this without frequent crashes. Most frequently (but not exclusively) when creating/editing tables.
Great tool for the experienced MySQL user!
NLBigs
Pros
Cons
Summary
This review was originally posted on VersionTracker.com.<br />It's fast, it's versatile, it's got a nice interface, it's just what I was looking for :)
Wow, a tremendous tool making great progress
neb_orbit_greely
Pros
Cons
Summary
This review was originally posted on VersionTracker.com.<br />I'm really surprised at how this free tool from mysql.com seems to be slipping under the radar.
I've been a cocoamysql user for some time -- and while cocoamysql is a nice tool, it hasn't seen development in eons and it has a lot of limitations.
Mysql.com is obviously gunning to make MySQL Query Browser a top notch tool and it is equal to or better than every other mysql query tool I've tried.
This app is far closer to the advanced functionality of an app like safari, note that you can:
run multiple queries in tabs
keep a query history (that spans days)
bookmark queries
to name a few similarities.
Here are a few other features that are worth noting:
The entire mysql reference is built right into the app. sweet.
You can compare resultsets [ run two queries and it'll highlight line by line the differences between them], very cool.
it highlights tablenames/column names as you type the query so you're not always trying to guess what you named the 8th column in your six table.
While it has a few interface quirks (run a query, then select 'Explain Query', now select 'Explain Query' again, and again, now try to get rid of any of those panes -- or type a query that doesn't work, it'll disappear) I'm going to peg this at 5 stars as the best free tool I've seen for mysql yet.