Is there a way with InnoDB tables to see all related tables/columns?
Basically what I want to do is make a script that somehow will dynamically
create a backup of a single user record. But I don't want to have to
manually add a new table or column everytime to the script.
So for example, I have
That is, as far as I know, impossible. Mysql does not know which
tables are related to which ones.
Peter
On 6/30/06, Daevid Vincent [EMAIL PROTECTED] wrote:
Is there a way with InnoDB tables to see all related tables/columns?
Basically what I want to do is make a script that somehow will
-Original Message-
From: Peter Van Dijck [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 6:32 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Need way to see all relations?
That is, as far as I know, impossible. Mysql does not know which
tables are related to which
: mysql@lists.mysql.com
Subject: Re: Need way to see all relations?
That is, as far as I know, impossible. Mysql does not know which
tables are related to which ones.
Peter
On 6/30/06, Daevid Vincent [EMAIL PROTECTED] wrote:
Is there a way with InnoDB tables to see all related tables
Daevid,
I have a 'users' table. And there are all kinds of related
tables like 'logs', 'preferences', etc. that all have a FK
reference back to this user ID.
I want to make a query or use some PHP to build a list of
all tables in my DB that are references.
Query to find tables with FK
EXCELLENT! Thanks!
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Friday, June 30, 2006 8:31 PM
To: Daevid Vincent
Cc: mysql@lists.mysql.com
Subject: Re: Need way to see all relations?
Daevid,
I have a 'users' table. And there are all kinds of related
