Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

After working a while with Access 2010 I have fell in love with the way you make queries. You just pick the tables you want in your SELECT query, then you get all the JOINs laid out automatically, and you can just pick and choose what you want.

However, I cannot find any good similar tools for MySQL. I tried MySQL Workbench once, but it wasn't very easy to use compared to Access. I'm seriously considering making a parallel Access database to construct the JOINs, even though it requires me to do structural changes both in Access and phpMyAdmin, and to make dummy data in Access, and to convert the SQL to MySQL-friendly code..

Are there any GOOD tools out there to help me do this instead of my Access/MySQL in parallel approach?

share|improve this question
If you end up not finding something you like then instead of duplicating your solution you'd be better off just learning the SQL syntax to write your own joins. It would be far beneficial in the long run. The skills are more widely applicable. – squillman Oct 1 '12 at 19:14
@squillman No, they aren't difficult. The reason why I prefer it is because when I have two tables with 5 tables in between (graphically), it takes a lot of time to write the joins... And you have to print out a graphical representation, or draw one, so you can "find your way" when you are doing joins. Because remembering the way when you have 30 tables isn't easy. – Friend of Kim Oct 1 '12 at 19:16

2 Answers

up vote 2 down vote accepted

You can try SQLyog- MySQL GUI which provides you with a powerful GUI (graphical) Query Builder which supports JOINs as well. enter image description here

share|improve this answer
up vote 2 down vote

You can try Visio. Here's a related SO post.

Here's a how-to about making the connection.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.