What is an easy way to design MySQL Queries?
A:
Maybe you want a GUI designer, something like MySQL workbench? Others I've heard of:
FrustratedWithFormsDesigner
2010-04-13 19:03:44
+2
A:
A good GUI management system certainly helps. Here's a couple of links to two of my favourites - both of which are available as free editions, but there's no shortage.
SQLyog Community Edition. Very straightforward interface which does all I need 98% of the time without excess baggage getting in the way. There's a commercial version which is quite expensive and adds a few extra useful management features.
Toad for MySQL. Well respected and somewhat more poweful that SQLyog. There's versions of Toad for MSSQL and Oracle too.
Cruachan
2010-04-13 19:19:19
As a long time user of SQLyog, and a developer using MySQL, I found that the best way to design queries is to type them out and test them in SQLyog then refactor them for speed and memory once results are obtained. To this day i have failed to find or use effectively point and click (drag and drop) UI (DIE MICROSOFT ACCESS DIE!!).
jake
2010-07-02 06:45:01
@Jake = broadly I would agree with you, if I'm creating queries myself more often than not I construct from scratch as text. The big win I find for GUI tools though are if I have a really complex (8 way join +) sql query I'm looking at for the first or in a long time - picking it up and dropping it into a GUI to see the structure is often the fastest way to get to grips with it
Cruachan
2010-07-02 09:36:02