delete - constraint without InnoDB?
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
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.