# [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 while delete the tno in p_program_type,the p_schedule table
> would delete the data matching p_schedule table.
"ON DELETE"
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html
--
If you cc me or remove the list(s) completely I'll most likely ignore
your message. see http://www.eyrie.org./~eagle/faqs/questions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
