Sorry if this question is naive, but I was unable to understand possible usage of RESTRICT or No ACTION. Consider a simple database of
CREATE TABLE column1 ( first_id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (first_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci"; CREATE TABLE column2 ( second_id int(11) NOT NULL AUTO_INCREMENT, first_id int(11) REFERENCES column1(first_id) ON DELETE CASCADE, PRIMARY KEY (second_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
DELETE FROM column1 WHERE first_id='XX'the corresponding row in the column2 (child column) will be deleted
DELETE FROM column2 WHERE first_id='XX'nothing will be deleted from column1 (parent column)
Right? then, what and how
NO ACTION can change this scenario ?