Unanswered: ON UPDATE CASCADE and Delete operations
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?