MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table F (id_f INT NOT NULL PRIMARY KEY, 
                fk_1 INT, 
                fk_2 INT, 
                column_F CHAR(2), 
                INDEX idx (fk_1, fk_2));
INSERT INTO F VALUES
(1,1,1,'AA'),
(2,1,2,'BB'),
(3,1,2,'CC'),
(4,2,1,'DD');
SELECT * FROM F;


id_f
fk_1
fk_2
column_F


1
1
1
AA

2
1
2
BB

3
1
2
CC

4
2
1
DD


create table A (id_a INT NOT NULL PRIMARY KEY, 
                fk_1 INT, 
                fk_2 INT, 
                FOREIGN KEY (fk_1, fk_2) REFERENCES F(fk_1, fk_2));
INSERT INTO A VALUES
(1,1,1),
(2,1,2),
(3,2,1);
SELECT * FROM A;


id_a
fk_1
fk_2


1
1
1

2
1
2

3
2
1


DELETE FROM F WHERE column_F = 'CC';
Cannot delete or update a parent row: a foreign key constraint fails (`fiddle_PCNGSDKDSVWAUIOEDZBB`.`A`, CONSTRAINT `A_ibfk_1` FOREIGN KEY (`fk_1`, `fk_2`) REFERENCES `F` (`fk_1`, `fk_2`))

SELECT @fk_1:=fk_1, @fk_2:=fk_2
FROM F
WHERE column_F = 'CC';


@fk_1:=fk_1
@fk_2:=fk_2


1
2


UPDATE A JOIN F USING (fk_1, fk_2)
SET A.fk_1 = NULL, A.fk_2 = NULL
WHERE F.column_F = 'CC';
DELETE FROM F WHERE column_F = 'CC';
UPDATE A
SET fk_1 = @fk_1, fk_2 = @fk_2
WHERE fk_1 IS NULL 
  AND fk_2 IS NULL;
SELECT * FROM F;


id_f
fk_1
fk_2
column_F


1
1
1
AA

2
1
2
BB

4
2
1
DD


SELECT * FROM A;


id_a
fk_1
fk_2


1
1
1

2
1
2

3
2
1