split a table into two

2008-07-04 Thread Chandra N
Hi,   How to split the datas in a table into two table. Please help me.

delete a data from 3 tables

2008-06-17 Thread Chandra N
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_

delete a data from 3 tables

2008-06-17 Thread Chandra N
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