|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
Hi,
I'm looking for a tool giving the capability to browse the database data by the tables relations. For instance, if I have a customer table with a key linking on the customer's city, if I click on a customer row, I'd get the corresponding city data, and so on if the city table contains links to other tables. I tried google, mysql web site, and sourceforge, and I got nothing. Thanks jm |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
On Mon, 22 Oct 2007 11:18:35 +0200, jean-michel bain-cornu
<nospam@nospam.fr> wrote: >Hi, > >I'm looking for a tool giving the capability to browse the database data >by the tables relations. >For instance, if I have a customer table with a key linking on the >customer's city, if I click on a customer row, I'd get the corresponding >city data, and so on if the city table contains links to other tables. > >I tried google, mysql web site, and sourceforge, and I got nothing. > >Thanks >jm Correct me if I'm wrong, but I think PHPMyAdmin does that automatically once you define the relations in the schema as foreign keys ("references" constraint). In older versions one had to define the relations in the 'pma' database, which is part of PHPMyAdmin. -- ( Kees ) c[_] Dyslexics of the World, Untie! (#457) |
|
![]() |
| Outils de la discussion | |
|
|