Re: delete a data from 3 tables

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

R: delete a data from 3 tables

Nanni -Messaggio originale- Da: Chandra N [mailto:[EMAIL PROTECTED] Inviato: martedì 17 giugno 2008 12.06 A: mysql@lists.mysql.com Oggetto: delete a data from 3 tables hi all   I created 3 tables namely authen_tbl,profile_tbl,astro_tbl,in which column name mail  as primary key in

Re: delete a data from 3 tables

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

delete a data from 3 tables

hi all   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_

R: delete a data from 3 tables

; Aloha! Claudio Nanni -Messaggio originale- Da: Chandra N [mailto:[EMAIL PROTECTED] Inviato: martedì 17 giugno 2008 9.44 A: mysql@lists.mysql.com Oggetto: delete a data from 3 tables hi,   I would like to know how to delete a data from 3 table which is interconnected with each other by f

RE: delete a data from 3 tables

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

Re: delete a data from 3 tables

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

delete a data from 3 tables

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.   Thanks chandra