MySQL Query Browser (1.0.7 Beta) Now Available

[Birdman]

MySQL Query Browser is a visual query tool for creating, executing and
optimizing MySQL database queries in a GUI environment. MySQL Query
Browser is available for Linux and Windows. Features include:
* Query history and bookmarking
* Tabular visualization of results
* Side-by-side result set comparisons

To read the documentation, visit:
[dev.mysql.com...]

Source and binaries are available to download:
[dev.mysql.com...]

[henry0]

Hello Birdman
very interesting - thank you-
I might if I get the chance (This weekend) try it and add it later (as an alternative) to
Apache server Tutorial [webmasterworld.com]
I will then report.

Sorry for the bit of internal SPAM cannot resist :)
Regards

Henry

[txbakers]

Thanks for posting that. looks like a good tool.

[Birdman]

You are both welcome!

I installed it last night and it is pretty nice! Very fast compared to phpmyAdmin. Of course, time will tell...

I like this feature:

The MySQL Query Browser supports some very handy "query composition" features. You can quickly build SQL queries with drag&drop and mouse clicks.

By selecting a table from the database list and dragging it over the query entry box, an action bar with some query composition actions will pop-up. Drop the table you're dragging on the desired action and the query will be modified accordingly. The following actions are possible:

Birdman

[killroy]

Hmm, I've always created my queries with a few copies of mysql.exe console open and a tabbed text editor with my queries in text files. I've always found that query editors break down for complex queries. What tools do you use for queries that are several pages long and span a dozend tables or multiple databases?

SN

[Birdman]

I've always found that query editors break down for complex queries

Why don't you give it a go and let us know if it can handle your requirements. Just because you have experienced certain limitations in other tools doesn't mean that they all future ones will fall down.

What tools do you use for queries that are several pages long and span a dozend tables or multiple databases?

Whoa! Above my head :)

Birdman

[henry0]

Killroy,
In the tool box! there is one tool very powerful which I believe is named MySQl manager2

I have used it once; works quite well
not free as I remember but affordable

Regards

Henry

[killroy]

Hehe, ok, got me. I'll get it and test it on one of my medium sized log queries.

SN

[ergophobe]

I've used mysql-front for query *sets* that cover many pages and dozens of tables. I don't think it would have any trouble with complex single queries since it's just a front end for the command line interface. I don't think it's free anymore though, so if there's a nice tool distributed for free with MySQL, that will likely be the end of it.