Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Is there any free tools that would let me build queries like one can in Access?

share|improve this question

closed as off-topic by Jens Erat, random Aug 4 at 15:28

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

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Jens Erat, random
If this question can be reworded to fit the rules in the help center, please edit the question.

4 Answers 4

up vote 1 down vote accepted

Yes there are - you can download the open source MySQL Workbench (screenshots).

share|improve this answer
1  
This looks close, but I am having trouble finding a query designer. I can get the model of the schema to show up, and query things, but I am having trouble finding how to build the query graphically. –  Joshua Enfield Aug 18 '10 at 20:44
    
As far as I'm aware, there's no query browser. MySQL Workbench is indented as a database designer and creates the statements (or database directly) for MySQL. –  Force Flow Aug 18 '10 at 21:46
    
@Josh - have you tried following the instructions starting from dev.mysql.com/doc/workbench/en/wb-sql-development.html –  Hamish Downer Aug 18 '10 at 22:15

Try using SQLyog's powerful Query Builder. It is very easy and intuitive to use.

SQLyog Query Builder Screenshot

share|improve this answer

i can advice you this tool Heidi SQL it very lightweight and also can repeat all important functions of MySQL Workbench

Here you can find some screenshoots of this programm

share|improve this answer

I would recommend Navicat (Not free but has 30 days free trail).

It is a good tool as far as visual query building is concerned. :-)

share|improve this answer

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