MySQL query builder? (like Access has in Design View)

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

Joshua Enfield

Posted 2010-08-18T19:40:36.433

Reputation: 204

Answers

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

Hamish Downer

Posted 2010-08-18T19:40:36.433

Reputation: 3 064

1I didn't find any query builder on mysql workbench there!! – Anwar – 2015-10-04T14:24:11.720

4This 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 – 2010-08-18T20:44:42.147

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 – 2010-08-18T21:46:54.783

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

SQLyog Query Builder Screenshot

jsist

Posted 2010-08-18T19:40:36.433

Reputation: 181

But it's not free as is asked in question! – Siamak Ferdos – 2017-02-16T09:08:31.320

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

Ishikawa Yoshi

Posted 2010-08-18T19:40:36.433

Reputation: 825

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. :-)

Sagar Ranglani

Posted 2010-08-18T19:40:36.433

Reputation: 121