any mysql tools that can visually design queries?

[MossyUK]

Saw at work today Microsoft Visual Studio being used to develop ASPX applications. Was given a demo that was a lot like MS Access but you could draw out relationships and insert criteria and the SQL would be produced including the joins and everything. I wondered if MySQL has anything similar? Does Zend Studio include this? Thanks

 

[Gman]

not that i know of, i think the best thing would be to re-create the same database if it isn't too big in access and use the query builder in that then copy and past the generated sql statement into your mysql site code.

but saying that just done a search and http://www.navicat.com/index.html says its got a query builder facility, might be worth downloading the trial version to see what it's like. Theres also this app http://www.microolap.com/products/database/myisql/ again not sure how good they are but theres demo's avaliable, not sure i would be able to justify buying them though as if i was desperate i'd just use access's or visual studios and copy and past the statement.

 

[Hades]

Just a thought. Could you not use Access and an ODBC driver to MySQL? In other words design the query in Access (visual gui) and connect to MySQL for the actual storage?

No idea if it can be done using MySQL but I do it at work with Access as a front end to Oracle on remote Unix boxes.

But tbqh it's often better to learn SQL and not need a gui.

 

[chesterstu]

Very interesting this came, i was considering designing something like this for my Dissertation. Do people think it is something they would use?

PS Sorry to hijack your thread

 

[Hades]

Very interesting this came, i was considering designing something like this for my Dissertation. Do people think it is something they would use?

PS Sorry to hijack your thread

I think it would be used to some extent. But personally I find I rarely use GUI's and tend to prefer editing directly, whether that's SQL, Java classpaths, XML, etc, etc.