Re: Foreign Key Concept

2003-06-24 Thread Egor Egorov
"MaFai" <[EMAIL PROTECTED]> wrote: > > After I create this table,and add foreign key tno to this table. > If I delete "tno" in "p_program_type" table,it would alarm that some data still in > "p_schedule". > How can I define the "p_schedule" or "p_program_type" table to make sure that while > del

Re: Foreign Key Concept

2003-06-24 Thread Roman Neuhauser
# [EMAIL PROTECTED] / 2003-06-24 16:48:24 +0800: > After I create this table,and add foreign key tno to this table. > If I delete "tno" in "p_program_type" table,it would alarm that some > data still in "p_schedule". > How can I define the "p_schedule" or "p_program_type" table to make > sure that

Foreign Key Concept

2003-06-24 Thread MaFai
Hello, mysql, After I create this table,and add foreign key tno to this table. If I delete "tno" in "p_program_type" table,it would alarm that some data still in "p_schedule". How can I define the "p_schedule" or "p_program_type" table to make sure that while delete the tno in p_program_type,the