I'm new to the ON DELETE and ON UPDATE options for foreign keys and am trying to make sure I understand their behaviour.

If I define a foreign key using ON UPDATE CASCADE what happens if the corresponding row in the parent table is deleted? Does it function similar to ON DELETE SET NULL and set the value of the column to NULL? If not, can I use
"ON DELETE SET NULL ON UPDATE CASCADE" to ensure that both updates and deletes are handled properly?


Cheers, Kris

nothing

ON UPDATE defines what happens when the corresponding key in the parent table is updated

only if those (set null and cascade, respectively) are the proper actions that you want done in the case of deletes or updates