Re: MySQL DELETE QUERY HELP PLZ ! ! !

[Peter Brawley]

CREATE TABLE models (
mod_aa INT PRIMARY KEY
, ...
) ENGINE=INNODB;

CREATE TABLE product (
prod_aa INT PRIMARY KEY,
mod_aa INT,
...,
INDEX(mod_aa),
FOREIGN KEY(mod_aa) REFERENCES models ON DELETE CASCADE
) ENGINE=INNODB;

and so on down the parent-child chain.

PB