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');

Records: 4  Duplicates: 0  Warnings: 0


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, 
                CONSTRAINT fk_idx 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);

Records: 3  Duplicates: 0  Warnings: 0


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`.`A`, CONSTRAINT `fk_idx` FOREIGN KEY (`fk_1`, `fk_2`) REFERENCES `F` (`fk_1`, `fk_2`))


ALTER TABLE A DROP FOREIGN KEY fk_idx;

Records: 0  Duplicates: 0  Warnings: 0


DELETE FROM F WHERE column_F = 'CC';
ALTER TABLE A ADD CONSTRAINT fk_idx FOREIGN KEY (fk_1, fk_2) REFERENCES F(fk_1, fk_2);

Records: 3  Duplicates: 0  Warnings: 0


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