Is there some reason why you don't just delete from the third table first,
then the second then the first? Or maybe the reverse order, depending on
your key - it's hard to get a good idea of the structure when you just say
"1st table is connected with 2nd table by foreign key." Just be sure you
d
Hi,
>I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column
name mail as primary key in authen_tbl table ,
>query:
>pid int primary key auto_increment,
>foreign key (mail) references authen_tbl(mail)
>given in astro_tbl table
>and
>query
>foreign key(pid) references profile_tbl
Hi
Please let us know the table structures of all.
Thanks & Regards,
Dilipkumar
-Original Message-
From: Sebastian Mendel [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2008 1:22 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: delete a data from 3 tables
Cha
Chandra N schrieb:
hi,
I would like to know how to delete a data from 3 table which is interconnected with each other by foreign key.
i.e 1st table is connected with 2nd table by foreign key and 2nd table is
connected with 3rd table with foreign key.
please help to solve this problem.
What
