MySQL frontend that displays outer rows nested in table rows?

One day I came across a MySQL Frontend application that displayed external related rows in the parent row if, for example, the Client table has a foreign key to the Suburb table:

alt text
(source: vb123.com )

Do you know any interface that can do this?

+4
source share
3 answers

SQL Maestro Popup Subtests for Foreign Strings

http://www.sqlmaestro.com/products/mysql/maestro/screenshots/getting_started/data_grid/

SQL Manager for MySQL can view the table data in "multilevel mode":

http://www.sqlmanager.net/products/mysql/manager/screenshots/777

SQL Edge has a “relationship view” that displays outer rows:

http://www.baybreezesoft.com/images/treevw.jpg

+2
source

phpmyadmin has a parameter

see server configuration and link page in pma wiki

+1
source

Access to Microsoft can do it for mySQL

Here is more detailed information on the topic.

This means that you can open a table or query, and then select a subdirectory in the insert menu. Then you use the child and main fields of the wizard to get the screen you need.

You can also try the database client at openoffice.org

Unfortunately, I was browsing Navicat, but it does not do what you are looking for, so all I found is Microsoft Access.

+1
source

Source: https://habr.com/ru/post/1304010/


All Articles