When ON delete set NULL is active, when a record is deleted from the parent table, all records in the child table with matching foreign key values are set to NULL.

当ON DELETE SET NULL规则被激活时，如果一条记录从父表中删除，子表中的所有记录以及匹配的外键值都被设置为NULL。

youdao

With compelling content, a massive audience, and an active set of contributors, this community is key to aligning 50 Cent not just with his own music but with the global Hip Hop population.

FORBES: Social Media: Evolving From Broadcasting To Conversation