turb — 2011-01-30T11:49:09-05:00 — #1
here's the situation. Let's say I have a product database where one product have multiple entry in those tables:
Is there a quick way to remove from all those tables any row related to a specific product without having to execute 5 queries in this case?
swampboogie — 2011-01-30T12:07:35-05:00 — #2
Define foreign key constraints with on delete cascade. Note that not all database engines for Mysql support foreign keys.