From: Daevid Vincent Date: July 1 2006 1:44am Subject: RE: Need way to see all relations? List-Archive: http://lists.mysql.com/mysql/199550 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable That doesn't seem right. I know that MYISAM tables don't understand relations, but INNODB tables most certainly understand foreign key constraints and in fact cause me a lot of grief sometimes when trying to insert a record or create a new table that violates said constraints ;-) D=C6VID =20 > -----Original Message----- > From: Peter Van Dijck [mailto:petervandijck@stripped]=20 > Sent: Friday, June 30, 2006 6:32 PM > To: Daevid Vincent > Cc: mysql@stripped > Subject: Re: Need way to see all relations? >=20 > That is, as far as I know, impossible. Mysql does not know which > tables are related to which ones. >=20 > Peter >=20 > On 6/30/06, Daevid Vincent 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=20 > will dynamically > > create a "backup" of a single user record. But I don't want=20 > to have to > > manually add a new table or column everytime to the script. > > > > So for example, I have a 'users' table. And there are all=20 > kinds of related > > tables like 'logs', 'preferences', etc. that all have a FK=20 > reference back to > > this user ID. > > > > I want to make a query or use some PHP to build a list of=20 > all tables in my > > DB that are references. > > > > Then I can just dump out that user ID (via this script) and=20 > it will backup > > that user and all related table data across all tables. > > > > =D0=C65=CF=D0 > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: =20 > http://lists.mysql.com/mysql?unsub=3Dpetervandijck@stripped > > > > >=20 >=20 > --=20 > find videoblogs: http://mefeedia.com > my blog: http://poorbuthappy.com/ease/ > my job: http://petervandijck.net >=20