Posted by kenoli on 01/24/07 22:13
I have 4 tables (Let's say: t1, t2, t3, t4). One has a person_id
column as a native key and the others have a person_id column as a
foreign key.
Periodically, I want to remove all records in all tables with a given
person_id value. The MYSQL manual seems to say I should enter the
tables twice like this:
DELETE t1 t2 t3 t4 FROM t1 t2 t3 t4 WHERE . . . (which makes no sense
to me)
Then I'm not sure how to indicate the person_id value for all tables.
I'd like to just do:
DELETE t1 t2 t3 t4 FROM t1 t2 t3 t4 WHERE person_id = '69'
But this doesn't work. Do I need to do something like:
DELETE t1 t2 t3 t4 FROM t1 t2 t3 t4 WHERE t1.person_id = '69' AND
t2.person_id = '69' etc.
At any rate, I've tried various combinations here and haven't found
anything that works.
Please help!
--Kenoli
[Back to original message]
|