Geek Answers Handbook

Is there a mySQL interface that has an interface for connections?

Are there any mySQL interfaces like phpmyadmin that have a GUI for connections?

I know that you can run saved queries (which may include joins) in phpmyadmin, but I'm looking for a user-friendly way to solve other interfaces. I don’t need an external interface, I just want to see how others do it.

If not, what would be a good way to get closer to creating a connection interface?

Currently, I think, given the table student and enrollment (as a simple example), so that

 student table +---------------------------+ | id | name | number | +------+--------+-----------+ | 2 | Joe | 04567843 | | 3 | Jim | 43243254 | | 4 | Jack | 23145671 | +------+--------+-----------+

and..

 enrollment +---------------------+------------+-----------+ | id | student_id | course_id | score | +------+--------------+------------+-----------+ | 1 | 2 | ma001 | 86% | | 2 | 2 | en001 | 46% | | 3 | 3 | ma001 | 78% | +------+--------------+------------+-----------+

The interface can allow you to select the main table and the fields you need, then the secondary table and the necessary fields. And finally, the JOIN input field, where you select the type of connection and the fields connecting it (see. Image).

Image is a layout using firebug manipulating phpmyadmin to show what I mean (hopefully)

enter image description here

I understand that these are 2 questions, but are very closely related to each other, but to summarize, is there such a front end? And if not, will there be an approach described above?

+4
source share
4 answers

If you want to see how others do it, play a little with Microsoft Access. eg enter image description here

+1
source

Many tools currently provide this feature.

SQLYOG is what I use ... although I rarely use my query builder ... they have one that allows you to join ...

DB Forge has a query builder with the join function turned on ... http://www.devart.com/dbforge/mysql/studio/ I was going to publish a link to the query builder, but this site policy forbids me to post more than two links :(

Check out this link as it also contains a screenshot ... a smaller url, so replace it. for point and / for slash

www dot activequerybuilder dot com slash screenshots.html

By the way, MySQL's own MySQL tool, which I find excellent, also contains this function ... http://dev.mysql.com/doc/query-browser/en/mysql-query-browser-using-graphicalbuilding.html

+2
source

Not sure how good this is, but it claims to visually create connections: http://www.cgiscriptshop.com/products/mdm/index.html

Right on the page it says:

 Visually compose SELECT query, joining several tables.
0
source

You can check out Navicat Premium . It has a Visual SQL Builder that sounds like you're looking.

0
source

More articles:


All Articles