添加外键:
ALTER TABLE `order_detail`
ADD FOREIGN KEY (order_id)
REFERENCES `order`(id)
ON DELETE CASCADE
ON UPDATE CASCADE;
查看数据库表的创建表的语句:
添加外键:
ALTER TABLE `order_detail`
ADD FOREIGN KEY (order_id)
REFERENCES `order`(id)
ON DELETE CASCADE
ON UPDATE CASCADE;
查看数据库表的创建表的语句: