mysql - Mysql如何将约束从删除限制上的更新限制更改为级联

Question

我有一个表，我通过这个语句添加了一个外键约束

ALTER TABLE `t_Accounts` ADD CONSTRAINT `Relationship51` FOREIGN KEY (`Account_Group_Id`) REFERENCES `t_Accounts_Groups` (`Account_Group_Id`) ON DELETE RESTRICT ON UPDATE RESTRICT;
 

现在我想将它从 ON DELETE RESTRICT ON UPDATE RESTRICT 更改为 ON DELETE CASCADE ON UPDATE CASCADE。我怎么能做到这一点。

标签： mysqlconstraints