mysql级联删除外键约束_MySQL外键约束，级联删除

小编典典

如果您的级联删除某个产品是因为该产品属于被杀类别的成员，那么它会删除该产品，那么您的外键设置不正确。给定示例表，您应该具有以下表设置：

CREATE TABLE categories (

id int unsigned not null primary key,

name VARCHAR(255) default null

)Engine=InnoDB;

CREATE TABLE products (

id int unsigned not null primary key,

name VARCHAR(255) default null

)Engine=InnoDB;

CREATE TABLE categories_products (

category_id int unsigned not null,

product_id int unsigned not null,

PRIMARY KEY (category_id, product_id),

KEY pkey (product_id),

FOREIGN KEY (category_id) REFERENCES categories (id)

ON DELETE CASCADE

ON UPDATE CASCADE,

FOREIGN KEY (product_id) REFERENCES products (id)

ON DELETE CASCADE

ON UPDATE CASCADE

)Engine=InnoDB;

这样，您可以删除产品或类别，只有category_products中的关联记录会一起消失。级联将不会沿着树走得更远ÿ