Alex Rivera | Logout

MySQL tools which ease creation of SQL JOIN statements?

Asked 2008-09-17T12:56:24.217
9

Does anyone know tools which look at a MySQL database, show you all the tables graphically and allow you to create complicated JOIN statements via drag-and-drop?

sql mysql
Edit
Report

1 Answer

4

Before you buy anything, see if the free, official MySQL's GUI tools (specifically the MySQL Query Browser) will work for you.

Personally, I'm fairly comfortable interacting with MySQL's command line interface and haven't used their GUI tools very much, but I just downloaded Query Browser and it seems like it does exactly what you're looking for.

Also, check out "Building Queries Visually in MySQL Query Browser" for a nice tour of MySQL Query Browser.

answered 2008-10-01T03:58:06.137

Your Answer