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。
2
The combined record is much easier to use-you only have to check the PICTURE field to see if it's not null (which was the result of the LEFT OUTER JOIN).