MySQL Forums
Forum List  »  Newbie

relations and integrity...
Posted by: Iñaki MArtinez
Date: September 05, 2004 02:54PM

Hi!!!!

I have this problem....

I have a table with artist data and other table with biography, but the biography it is in several languages.... this way....

table artist
artist_id (primary key)
artist_name
artist_bio_id (foreing key) points to bio_id
......

table bio_en
bio_id
bio_text
bio_update


table bio_fr
bio_id
bio_text
bio_update

table bio_it
bio_id
bio_text
bio_update

Table_bio_XX are ALL identical (= the same structure) but diferent language.

So what i want is that when an artist is deleted **ALL** his biographies are deleted......... (= Integrity......)

How to set up this????


Thanks....


NOTE: sorry for my bad English...


Options: ReplyQuote


Subject
Written By
Posted
relations and integrity...
September 05, 2004 02:54PM
September 06, 2004 03:13AM
September 11, 2004 09:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.