News

When defining foreign key relationships, you can use ON DELETE CASCADE or ON UPDATE CASCADE to specify what should happen to dependent rows when a referenced row in the parent table is deleted or ...
In the first statement, I use the ON UPDATE SET NULL option; in the second statement, I use the ON DELETE CASCADE ON UPDATE CASCADE option. Here’s an overview of what these constraints mean. SET ...