Mysql workbench foreign key options [Restrict, Cascade, Set Null, No Action], what do they do?

If you take one by one :

For both update and delete :

if you try to update / delete the parent row :

Restrict : Nothing gonna be delete if there is a child row

Cascade : the child row will be delete / update too

Set Null : the child column will be set to null if you delete the parent

No action : The child row will not be concern of the delete / update

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)