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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

closed as off-topic by bluefeet, Jon Seigel, Max Vernon, dezso, RolandoMySQLDBA Oct 7 '13 at 0:45

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Jon Seigel, Max Vernon, dezso
If this question can be reworded to fit the rules in the help center, please edit the 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

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

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

share|improve this answer

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