MySQL Forums
Forum List  »  Newbie

delete - constraint without InnoDB?
Posted by: oliver voegeli
Date: August 09, 2005 07:55AM

hello!

given I have two tables T1 and T2 (mySAM) with a 1:m relationship:

T1:
t1ID | text
1 | bla bli
2 | bla blo
etc.

T2:
t2ID | t1ID | text
1 | 1 | bla bla bla
2 | 1 | blo blo blo
3 | 2 | bla bli blo

now I'd like to delete a row in T1, due to the 1:m relationship I'd also like all records in T2 with the same foreign key t1ID. is that possible to do within one sql-statement? or how could I solve it best?

thx in advance for any help!
oliver

Options: ReplyQuote


Subject
Written By
Posted
delete - constraint without InnoDB?
August 09, 2005 07:55AM


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.