references question

Hello,

I am wondering how do you use references correctly so when I delete a row from one table, similar rows will be deleted from other tables?

Thanks

Couldn't you just do multiple queries.

haha Im just too lazy, that's all..=p

are you using mysql 4.x or 3.x?, In general, you should probably just use 2 queries and say:

DELETE FROM 'tableone' WHERE id = value;
DELETE FROM 'tabletwo' WHERE tableoneid = value;

that is for 3.x, there is a new table type in mysql 4.x that incorporates some referential integrity stuff, but I haven't looked into it.